PowerLab400
Articles Guides Recipes Tools Software Errors Releases Jobs Other blogs
Log in

Browse

Loading…

The list did not load. Open as a page

Categories

All Software Hardware RPG Other Database System Security

Database

3 articles

Featured Database

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.

Read the article
27 Jul 2026 Database

Understanding journals and how to use them

The journal records every change to your data, with the time and the name of who made it. It exists for recovery, but day to day it mostly answers one question: who changed this record?

27 Jul 2026 Database

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.

View all articles

Most read

  1. 1 Setting up IBM i Access Client Solutions
  2. 2 Project4i: what if sources had a project?
  3. 3 Administering an IBM i: how the system works
  4. 4 IBM i 7.6 TR2 and 7.5 TR8: what is in them
  5. 5 Programming on IBM i: sources, ILE, RPG and SQL

Stay updated

A note when a new article or a new tool goes up. Nothing else.


PowerLab400

Articles, guides and tools for IBM i and AS/400.

LinkedIn

Community

Home About us Contact Privacy and cookies

Categories

Software Hardware RPG Other Database System Security

Contact

studio@powerlab400.com Log in

© 2026 PowerLab400

Resources for IBM i / AS400

PowerLab400 is an independent site, not affiliated with or endorsed by IBM. IBM, IBM i, AS/400 and Power are trademarks of International Business Machines Corporation.

This site uses cookies. More information

Necessary only Accept