Reading a spooled file with SQL
Querying the contents of a spooled file without copying it into a physical file first.
Articles tagged #sql — 14 results
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.