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.
IBM i / AS400
Resources for IBM i
Technical articles, guides and utilities for people working on IBM i and AS/400. The tools run in the browser, with nothing to install.
Try the tool
Processing happens in the browser. No registration is required and no data is transmitted.
Tools ready to use
IBM i utilities: EBCDIC conversion, date formats, packed and zoned decimal, data reading. They run in the browser, with no installation.
12607272026-07-27
123.4512 34 5C
C1 C2 C3ABC
Guides
Complete treatments of a topic, split into chapters and kept up to date. Each guide states the date of the last review and the IBM i release it was verified against.
- Programming on IBM i: sources, ILE, RPG and SQL
- Administering an IBM i: how the system works
Recipes
Short solutions to recurring problems, with ready-to-use code and the caveats to consider before running it in production.
Recipes →Reference
CL commands with the abbreviation spelled out, CPF and SQLCODE messages with the most frequent cause, IBM i Services with the corresponding command. Searchable lists.
Reference →Software
Editor extensions, programs and command line tools useful for IBM i work. Unlike the tools on this site, which run in the browser, these are installed on your computer or on the system.
Software →IBM i releases
End of support dates for IBM i releases, contents of each version, and known incompatibilities introduced at each upgrade.
Is your release still supported? →Jobs
IBM i and AS/400 job listings, and people making themselves available. Every entry is reviewed before it appears and expires automatically.
Jobs →Latest articles
All articles →Project4i Git Mode: what changes for your source
Project4i is preparing Git Mode, with the repository on your own IBM i's IFS and promotion from a commit. How it works and what to prepare.
Integrated MFA in IBM i 7.6: benefits, risks, setup
What it actually adds to system security, which profiles cannot use it, and the setup procedure with the order to follow.
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.