Db2 for i

Showing 212

add extra detail to the view qsys2.AUDIT_JOURNAL_DATA_MART_INFO

for the AUDIT_JOURNAL_DATA_MART_INFO view please add a column for the number of records in the data mart file.

29 days ago in IBM i / Db2 for i 1 Not under consideration

Provide a C/C++ "API" or function to enable reading Deleted records from a database file.

Now that the system is "closed" we can't use our old ways to do certain things. There needs to be a way to go out to a database file record and programmatically "undelete" that record. That is, say I'm going to open file ABC using the open or fope...

about 1 month ago in IBM i / Db2 for i 1 Not under consideration

4 VOTE

Declare UTF-8 character lenght in SQL TABLE not in bytes

Currently, when I create a new table and declare a field, for example, of type CHAR(10) UTF-8, the system only allows for 10 characters if each character is 1 byte in size. If a character occupies 2 or more bytes, the field length is no longer suf...

2 months ago in IBM i / Db2 for i 2 Not under consideration

2 VOTE

Use job default CCSID for SQL (ie. instead of CCSID 65535)

When a system is currently configured with its CCSID set to 65535, this causes issues with SQL functions that require CCSID conversions (ex. JSON, HTTP, ...), for example Select cast(RESPO00001 as varchar(32)), cast(RESPO00002 as varchar(32)) from...

about 1 month ago in IBM i / Db2 for i 4 Not under consideration

4 VOTE

Getting the response as a stream from the HTTP functions in QSYS2

The HTTP functions wait until the entire response has been received before returning it. Returning the response as a stream, without waiting for it to be complete, it would result in better performance particularly with very large responses.

4 months ago in IBM i / Db2 for i 1 Not under consideration

29 VOTE

Implementation of restore function that does not change the state of the access path

We would like you to implement the restore function that does not change the state of the access path by implicitly shared access paths. Our customers are having trouble getting their program to do something unexpected by save and restore. We wou...

over 2 years ago in IBM i / Db2 for i 6 Not under consideration

6 VOTE

Full support of Field Reference File (FRF) in SQL

When creating tables via SQL it is not possible to use the concept of a FRF to define fields in a consistent way and especially query the catalogs later on to find the origin of a field. A workaround is a CREATE TABLE AS however this doesn't suppo...

6 months ago in IBM i / Db2 for i 1 Not under consideration

45 VOTE

Select into :dsArray

It would be great to be able to select columns from a table directly into a data structure array instead of going through the process of creating a cursor. Because a lot of times you just want the list of matches and then your done. It makes even ...

over 4 years ago in IBM i / Db2 for i 6 Not under consideration

10 VOTE

Create GenerateAndEmailSpreadsheet

With the addition of Generate Spreadsheet and Send Email both are valuable but the adoption would have quite a bit of use if we had one function that does both.

about 1 year ago in IBM i / Db2 for i 3 Not under consideration

17 VOTE

Require QIBM_DB_SECADM or similar to perform set session authorization

Today any user with *ALLOBJ is able to do the equivalent to sudo in Linux without the need of any password to become another user using set session authorization via SQL. Any user with *ALLOBJ can become Qsecofr by open strsql and run: “Set sessio...

almost 2 years ago in IBM i / Db2 for i 5 Not under consideration

Shape the future of IBM!

Search existing ideas

Post your ideas

Specific links you will want to bookmark for future use