Db2 for i

Showing 320 of 3951

Additional Information from QSYS2.PTF_INFO

For those PTFs that have special instructions it would be useful to include this information via a NULL capable column of type CLOB, for example call PTF_SPECIAL_INSTRUCTIONS, so that it can be queried via the QSYS2.PTF_INFO view. Currently there ...

3 months ago in IBM i / Db2 for i 2 Future 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 1 year ago in IBM i / Db2 for i 6 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...

10 months ago in IBM i / Db2 for i 5 Not under consideration

18 VOTE

UUID datatype for IBMi

A UUID is a Universally Unique Identifier, meaning that these identifiers are unique over your whole DB; even better unique" across space and time". UUID's are stored in 128bit format and follow a standarized format (rfc4122) This makes the type a...

11 months ago in IBM i / Db2 for i 4 Future consideration

4 VOTE

In SQL JSON_TABLE, add an option on timestamp columns to take into account or not the timezone offset

In the SQL function JSON_TABLE, when a timestamp value indicated with a time zone offset (e.g.: "yyyy-mm-ddThh:mm:ss.nnnnnn<+/-Offset>") is retrieved to produce a timestamp column, the resulting value is always an UTC value (by adding or sub...

3 months ago in IBM i / Db2 for i 2 Future consideration

1 VOTE

Add something like IF EXIST for a table, view, procedures, etc.

In SQL, I often need to check if a table exists and either delete or create it. I opened a case and was told the functionality does not exist. If a file exists, I need to delete/DROP it. Sometimes, I need to create the table.

22 days ago in IBM i / Db2 for i 1 Submitted

27 VOTE

New IBM i SQL Service to Retrieve Certificate Usage Information

Need a DB2 SQL Service equivalent to API : Retrieve Certificate Usage Information (QYCDRCUI, QycdRetrieveCertUsageInfo) Use Case: We already have the CERTIFICATE_INFO table function, this would allow to know the certificates used (by DCM applicati...

over 1 year ago in IBM i / Db2 for i 4 Future consideration

8 VOTE

provide readable format when consuming .xlsx using qsys2.ifs_read

Functionality will eliminate having to save xlsx as a csv prior to consuming with qsys2.ifs_read

6 months ago in IBM i / Db2 for i 2 Future consideration

3 VOTE

Add the Module feature to PL/SQL

To improve modularity and maintainability of PL/SQL code, could you please add to DB2 for i, the support of modules, which already exists on other DB2 platforms : https://www.ibm.com/docs/en/db2/9.7?topic=modules-referencing-objects-defined-in Thi...

2 months ago in IBM i / Db2 for i 1 Future consideration

6 VOTE

Add view or udtf JOB_QUEUE_ENTRIES

Because the view JOB_QUEUE_INFO already exist, so similar to the output_queue_xxx views the job_queue_entries view is missing select * from qsys2.job_queue_entrieswhere job_queue_name = 'QBATCH'

5 months ago in IBM i / Db2 for i 2 Future consideration

Shape the future of IBM!

Search existing ideas

Post your ideas

Specific links you will want to bookmark for future use

FILTER BY CATEGORY