IBM Support

QSYS2.PARSE_STATEMENT UDTF

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 UpdatesDb2 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":"BU054","label":"Systems 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":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
07 September 2021

UID

ibm11116561