News
Abstract
The PARSE_STATEMENT table function returns a list of object and column names that are used in most 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 IBM Documentation for details: PARSE_STATEMENT table function
Enhanced with IBM i 7.4 SF99950 Level 5 and IBM i 7.4 SF99704 Level 26:
- Add support for most objects in DDL statements
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 is 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
[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001go6AAA","label":"IBM i Db2-\u003ESQL Services \/ table functions"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2.0;and future releases"}]
Was this topic helpful?
Document Information
Modified date:
06 October 2023
UID
ibm11116561