Database changes

Release to release Database changes that should be considered

Change to SQL Call Level Interface (CLI) include sqlcli
Reserved keyword KEY is enforced
QSYS2.USER_STORAGE view change
QSYS2.USER_INFO and USER_INFO_BASIC view change
QSYS2.SYSCONTROLS view change
Change to implementation of shared common table expressions for SQL queries
New database monitor field indicating shared common table expressions for SQL queries
SQE Symmetric Multiprocessing Changes
Queries that compare a numeric value with blanks or an empty string will fail with SQLSTATE/SQLCODE ‘22023’/-302 or '53045'/-678
Removal of IBM Db2 for i: JSON Store Technology Preview
Change in LISTAGG error
Generate SQL will now produce SQL table names for VIEW and MQT definitions
QSYS2.SYSTEM_STATUS table function, QSYS2.SYSTEM_STATUS_INFO view, and QSYS2.SYSTEM_STATUS_INFO_BASIC view changes
SQL ILE RPG precompiler change for BOOLEAN support
CREATE TRIGGER and ALTER TRIGGER - MIRROR YES option removed
STACK_INFO unauthorized access default behavior change
Generate Data Definition Language (QSQGNDDL) API will now produce SQL table names for VIEW and MQT definitions

Parent topic: IBM i operating system