SQL inside programs
How to write SQL inside RPG, why SQLCODE zero does not mean everything went well, and where injection hides on this platform too.
Articles tagged #sql — 17 results
DDS and SQL: two ways of describing data
The same file is both a physical file and a table. When to stay with DDS, when to move to SQL, and what it costs not to decide.
SQLCODE -305: the FETCH that stops on NULLs
Eighty-two COALESCEs are not the answer. What is left in the variables when a FETCH meets a NULL, and why ALWNULL has nothing to do with it.
Reading a spooled file with SQL
Querying the contents of a spooled file without copying it into a physical file first.
Converting a CYYMMDD date in SQL
Turning the seven-digit format into a real date with a single expression.
Seeing which jobs use the most CPU
What WRKACTJOB shows on screen, but queryable and sortable.
Finding out how much space a library uses
And more to the point, which objects inside it are eating the space.
The indexes the system suggests, and which to create
Db2 for i records which indexes it would have wanted, one query at a time. Creating them all is the quickest way to slow the database down.