My ideas: Db2 for i

Showing 223

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...

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

37 VOTE

Exit Point QIBM_QDB_OPEN split

In the operating system there is one entry point DBOPEN Format DBOP0100 that takes care of database access. This is a really powerful exit point, because if activated it shows every access to a file. But on the other side is this exact the biggest...

over 5 years ago in IBM i / Db2 for i 12 Not under consideration

1 VOTE

Add SIRGAS 2000 as supported datum on DB2 for i

Since 2005, Brazil has adopted datum SIRGAS 2000 as its official Georeferencing System. Therefore, all information exchanged between government entities must adhere to this standard. It is also used by other Latin American countries. Thus, it woul...

about 2 months ago in IBM i / Db2 for i 2 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.

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

21 VOTE

Visual explain as a SQL - IBM i service

Visual explain is a vital tool to get the information about how a SQL statement is processed and to understand the nature of SQL queries. However, it can be quite complicated to oververview complicated queries and the graph can be quite chaotic. M...

over 3 years ago in IBM i / Db2 for i 3 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...

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

1 VOTE

SQL Update using Common Table Expresions

Currently an UPDATE statement that attempts to update a field with the selected value from a Common table expression causes an SQLCODE -199 with SQLSTATE 42601: "Illegal use of KeyWord UPDATE. Token ( SELECT VALUES was expected" --or something sim...

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

2 VOTE

chg sql to calculate in the right way

Sql calculate with the smalest decimalcalculate (in a Programm or in STRSQL)select Sum(1,25), sum(1,25/100)*19 from unique-file where unique-key in(a, b) --> 2 recordShow: 2,50 0,38 and that is wrong.of course if i think of it, ich can calculat...

4 months ago in IBM i / Db2 for i 1 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.

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

34 VOTE

allow three part names in db2 for i services

please add ability to use three-part naming in UDTF or in db2 for i services likeQSYS2.JOB_INFOIt seems that the 3-part naming isn't working or supported in UDTFs. .e.g.:https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20...

over 7 years ago in IBM i / Db2 for i 3 Not under consideration

Shape the future of IBM!

Search existing ideas

Post your ideas

Specific links you will want to bookmark for future use