IBM Support

Db2 for i Functional Enhancements

News


Abstract

Db2 for i Functional Enhancements Landing Page

Content

You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Functional Enhancements
 
 
Db2 for i Functional Enhancements
 
Db2 for i EnhancementIBM i 7.6IBM i 7.5IBM i 7.4IBM i 7.3
--- Enhancements from 2025 ---
INSERT with VALUES supports named column syntax  SF99960 Level 2SF99950 Level 11Not SupportedNot Supported
SYSTOOLS.EVEN and SYSTOOLS.ODD scalar functionsSF99960 Level 2SF99950 Level 11Not SupportedNot Supported
URL_ENCODE and URL_DECODE extended to handle 2 gigabyte values SF99960 Level 2SF99950 Level 11Not SupportedNot Supported
UPDATE and DELETE (SQL) statements supported as data-change table referenceBaseNot SupportedNot SupportedNot Supported
CONNECT statement supports additional factor for authenticationBaseNot SupportedNot SupportedNot Supported
SQLSTATE_INFO tableBaseSF99950 Level 9Not SupportedNot Supported
--- Enhancements from 2024 ---
GENERATE_UUID and GENERATE_UUID_BINARY scalar functionsBaseSF99950 Level 8SF99704 Level 29Not Supported
ANY_VALUE aggregate functionBaseSF99950 Level 7SF99704 Level 28Not Supported
CREATE ALIAS with *LAST memberBaseSF99950 Level 7SF99704 Level 28Not Supported
--- Enhancements from 2023 ---
ENCRYPT_AES256 scalar functionBaseSF99950 Level 5SF99704 Level 26Not Supported
HTML_ENTITY_DECODE and HTML_ENTITY_ENCODE scalar functionsBaseSF99950 Level 5SF99704 Level 26Not Supported
QSYS2 HTTP Functions - New HTTP header response controlsBaseSF99950 Level 5SF99704 Level 26Not Supported
QSYS2.PARSE_STATEMENT() table function enhancedBaseSF99950 Level 5SF99704 Level 26Not Supported
SYSTOOLS.SQLCODE_INFO()BaseSF99950 Level 5SF99704 Level 26Not supported
RESTRICT ON DROP for functions and proceduresBaseSF99950 Level 4Not SupportedNot Supported
ADD_DAYS, ADD_HOURS, ADD_MINUTES, ADD_SECONDS, ADD_YEARS scalar functionsBaseSF99950 Level 4SF99704 Level 25Not Supported
QSYS2 HTTP Functions - support BLOB typeBaseSF99950 Level 4SF99704 Level 25Not Supported
Extend Watson Geospatial AnalyticsBaseSF99950 Level 4SF99704 Level 25Not Supported
--- Enhancements from 2022 ---
Geospatial AnalyticsBaseSF99950 Level 3SF99704 Level 23Not Supported
REMOTE TABLEBaseSF99950 Level 3SF99704 Level 23Not Supported
REPLICATION_OVERRIDE global variable for system generated valuesBaseSF99950 Level 3SF99704 Level 23Not Supported
TIMESTAMPDIFF_BIG scalar functionBaseSF99950 Level 3SF99704 Level 23Not Supported
FIRST_DAY scalar functionBaseSF99950 Level 3SF99704 Level 23Not Supported
JSON_UPDATE scalar functionBaseSF99950 Level 3SF99704 Level 23Not Supported
QSYS2 HTTP Functions - HTTP options support for "headers"BaseSF99950 Level 3SF99704 Level 23Not Supported
Boolean data typeBaseBaseNot SupportedNot Supported
RESTRICT ON DROPBaseBaseNot SupportedNot Supported
TRY_CAST specificationBaseBaseSF99704 Level 20Not Supported
RUNSQLSTM command - MARGINS(*SRCFILE)BaseBaseSF99704 Level 20SF99703 Level 28
HTTP_PATCH and HTTP_PATCH_VERBOSE functionsBaseBaseSF99704 Level 20SF99703 Level 28
New response header format option for verbose HTTP functionsBaseBaseSF99704 Level 20SF99703 Level 28
--- Enhancements from 2021 ---
New HTTP functions based in QSYS2BaseBaseSF99704 Level 15SF99703 Level 26
SIGNAL detail from within a trigger can be accessed with GET DIAGNOSTICSBaseBaseSF99704 Level 13SF99703 Level 24
SYSIBM.CLIENT_IPADDR generated columns enhanced for non-TCP/IP based connectionsBaseBaseSF99704 Level 13SF99703 Level 24
RUNSQLSTM command - return TGTRLS in the listingBaseBaseSF99704 Level 13SF99703 Level 24
--- Enhancements from 2020 ---
DROP support for IF EXISTSBaseBaseSF99704 Level 10SF99703 Level 22
CREATE SEQUENCE supports FOR SYSTEM NAMEBaseBaseSF99704 Level 10SF99703 Level 22
SQL Precompiler additional support for WHENEVERBaseBaseSF99704 Level 10SF99703 Level 22
SQL precompilers support DBGVIEW(*STMT) and DBGVIEW(*LIST)BaseBaseSF99704 Level 10SF99703 Level 22
SELECTIVITY clause on queriesBaseBaseSF99704 Level 10SF99703 Level 22
SYSTOOLS.SPLIT table function supports ESCAPE parameterBaseBaseSF99704 Level 10SF99703 Level 22
Weakly typed distinct typesBaseBaseSF99704 Level 7Not Supported
JSON_TABLE enhanced to support JSON arraysBaseBaseSF99704 Level 7SF99703 Level 18
INTERPRET built-in functionBaseBaseSF99704 Level 7SF99703 Level 18
HASH_ROW built-in functionBaseBaseSF99704 Level 7Not Supported
Extended indicators in SQL PLBaseBaseSF99704 Level 7SF99703 Level 18
USING SUBSET on EXECUTE and OPEN with Extended indicatorsBaseBaseSF99704 Level 7SF99703 Level 18
Support TAG within ILE RPG Embedded SQLBaseBaseSF99704 Level 7SF99703 Level 18
ARRAY_TRIM and ARRAY_MAX_CARDINALITY SQL built-in function synonymsBaseBaseSF99704 Level 7SF99703 Level 18
QSYS2.ANALYZE_CATALOGBaseBaseSF99704 Level 7SF99703 Level 18
QSYS2.COMPARE_FILEBaseBaseSF99704 Level 7Not Supported
SYSTOOLS.VALIDATE_DATA, SYSTOOLS.VALIDATE_DATA_FILE, and SYSTOOLS.VALIDATE_DATA_LIBRARYBaseBaseSF99704 Level 7SF99703 Level 18
--- Enhancements from 2019 ---
Allow UTF-8 source for SQL precompilesBaseBaseSF99704 Level 4SF99703 Level 16
Add PROGRAM NAME for SQL routinesBaseBaseSF99704 Level 4SF99703 Level 16
New Synonyms added for Db2 Family compatibilityBaseBaseSF99704 Level 4SF99703 Level 16
Support greater than 32 routines over an external service programBaseBaseSF99704 Level 4SF99703 Level 16
HASH built-in functionsBaseBaseSF99704 Level 1Not Supported
SQE improvementsBaseBaseSF99704 Level 1Not Supported
INSERT with DEFAULT VALUESBaseBaseSF99704 Level 1SF99703 Level 15
CREATE INDEX - optional alias and rename controls for field namesBaseBaseSF99704 Level 1SF99703 Level 15
New QSQPRCED() - QAQQINI statement level override controlsBaseBaseSF99704 Level 1SF99703 Level 15
SQL precompiler enhancementsBaseBaseSF99704 Level 1SF99703 Level 15
SYSPROC.WLM_SET_CLIENT_INFO() procedure enhancedBaseBaseSF99704 Level 1SF99703 Level 15
QSYS2.PARSE_STATEMENT() table function enhancedBaseBaseSF99704 Level 1SF99703 Level 15
--- Enhancements from 2018 ---
OmniFind - Programmatic search of the IFSBaseBaseBaseSF99703 Level 11
Optional parameter support for external procedures and functionsBaseBaseBaseSF99703 Level 11
DECFLOAT_FORMAT() built-in functionBaseBaseBaseSF99703 Level 11
NOW() built-in function enhancedBaseBaseBaseSF99703 Level 11
EXTRACT() built-in function enhancedBaseBaseBaseSF99703 Level 11
VARCHAR_FORMAT() and TO_CHAR() built-in functions enhancedBaseBaseBaseSF99703 Level 11
Table correlation name enhanced to be optionalBaseBaseBaseSF99703 Level 11
JSON - Uniqueness controls for Key namesBaseBaseBaseSF99703 Level 11
JTOpen JDBC driver – Alternate server supportBaseBaseBaseSF99703 Level 11
--- Enhancements from 2017 ---
JSON publishing functionsBaseBaseBaseSF99703 Level 7
JSON scalar functionsBaseBaseBaseSF99703 Level 7
DELETE and UPDATE paginationBaseBaseBaseSF99703 Level 7
Full LIMIT and OFFSET supportBaseBase
Base
SF99703 Level 7
JSON query predicatesBaseBaseBaseSF99703 Level 4
LISTAGG() built-in functionBaseBaseBaseSF99703 Level 4
Enhanced LTRIM() and RTRIM() built-in functionsBaseBaseBaseSF99703 Level 4
Ability to use 3-part names from within trigger programsBaseBaseBaseSF99703 Level 4
--- Enhancements from 2016 ---
JSON_TABLE() table functionBaseBaseBaseSF99703 Level 3
QSYS2.PARSE_STATEMENT() table functionBaseBaseBaseSF99703 Level 3
Enhanced INCLUDE SQL statementBaseBaseBaseSF99703 Level 3
Debugger enhanced for SQL procedures, functions and triggersBaseBaseBaseSF99703 Level 3
OVERRIDE_QAQQINI() procedureBaseBaseBaseBase
--- Enhancements from 2015 ---
OFFSET and LIMITBaseBaseBaseBase
Remote 3-part name support on ASSOCIATE LOCATORBaseBaseBaseBase
LOCATE_IN_STRING() built-in functionBaseBaseBaseBase
OVERLAY() built-in functionBaseBaseBaseBase
Flexible viewsBaseBaseBaseBase
Direct control of system names for global variablesBaseBaseBaseBase
Create OR REPLACE tableBaseBaseBaseBase
New binary scalar functionsBaseBaseBaseBase
--- Enhancements from 2014 ---
Pipelined table functionsBaseBaseBaseBase
Regular expressionsBaseBaseBaseBase
LPAD & RPAD scalar functionsBaseBaseBaseBase
JOB_NAME & SERVER_MODE_JOB_NAME - DB2 built-in global variablesBaseBaseBaseBase
LOCK TABLE ability to target non-FIRST membersBaseBaseBaseBase
QSYS2.GENERATE_SQL() procedureBaseBaseBaseBase
QSYS2.DELIMIT_NAME() UDFBaseBaseBaseBase
 
Older Enhancements:
 
 
 

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHeAAM","label":"IBM i Db2"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2.0;and future releases"}]

Document Information

Modified date:
11 February 2026

UID

ibm11115697

Page Feedback