News
Abstract
The PARSE_STATEMENT table function returns a list of object and column names that are used in a subset of SQL statements.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Functional Enhancements > QSYS2.PARSE_STATEMENT UDTF
See the table function definition for details: PARSE_STATEMENT table function
Enhanced with IBM i 7.4 SF99704 Level 15 and IBM i 7.3 SF99703 Level 26:
- Add support for CALL statements
What's new with IBM i 7.4 SF99704 Level 1, and IBM i 7.3 SF99703 Level 15:
- Add support for DROP statements
- Add support for Referential Integrity constraints on CREATE TABLE or ALTER TABLE
- Return a warning if any error occurs during parsing and also if the input SQL_STATEMENT was NULL
What's new with IBM i 7.3 SF99703 Level 11 and IBM i 7.2 SF99702 Level 23:
- Return additional information:
- Table name for index and trigger
- Table name for CREATE TABLE LIKE
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"IBM i 7.4;IBM i 7.3","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
07 September 2021
UID
ibm11116561