Reading JSON with SQL on IBM i
A field holding JSON can be read with SQL. Four levels, from the first JSON_VALUE query to the cases where a value quietly comes out NULL.
Articles tagged #sql — 16 results
Exit points: checking who controls network access
FTP, ODBC and data transfer reach the database without going through menus. The two SQL views for checking who controls that access.
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.
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 maintained on IBM i: sources, ILE, RPG, CL, DDS and SQL, debugging and modernisation, with IBM sources.
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.