Measuring *PUBLIC before restricting it
QCRTAUT defaults to *CHANGE, so public authority is wider than anyone decided. How to measure it with SQL before restricting it.
Articles tagged #sql — 14 results
Turning on the audit journal and reading it with SQL
QAUDJRN is not on by default and cannot be enabled retroactively. The command to turn it on, the functions to query it, and the library they live in.
IBM i 7.6 TR2 and 7.5 TR8: what is in them
No revolution, but three or four things that take manual work off whoever administers the system. And one that concerns anybody sending mail from it.
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.
Programming on IBM i: sources, ILE, RPG and SQL
How software is written, compiled and kept alive here. For anyone arriving from other languages, and for anyone who has never read the reasons written down.
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.
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.