Programming on IBM i: sources, ILE, RPG and SQL
How software is written, compiled and kept alive on this platform. For anyone arriving from other languages, and for anyone who has worked here for years without ever seeing the reasons written down.
Articles tagged #sql — 9 results
Finding the indexes the system suggests
Db2 for i records which indexes it would have wanted: you only have to ask.
Finding and releasing held schedule entries
The number one cause of "it did not run last night", and how to notice before it happens.
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.
Reading a spooled file with SQL
Querying the contents of a spooled file without copying it into a physical file first.
Integrating IBM i with REST services
Calling an external API from an RPG program needs no extra software and no rewrite: it can be done in SQL, in a few lines. The available routes, and when each one makes sense.
Optimizing SQL Queries on DB2 for i
When a query slows down, the cause is almost always a missing index or a condition written in a way the database cannot use. Here is how to find out instead of guessing.