VALUES statements

DB2® Database for Linux, UNIX, and Windows supports VALUES statements; however, DB2 Database for z/OS® does not support stand alone VALUES statements outside of a CREATE TRIGGER statement. For VALUES statements in a pureQueryXML file, the value of the isBindable attribute is set to false and pureQuery Runtime does not bind them.

If your JDBC application runs against DB2 Database for Linux, UNIX, and Windows, it might use VALUES statements like a SELECT statement against a table or view storing the data that is returned. If you need these statements to run statically, you can rewrite VALUES statements as a series of unions of SELECT FROM SYSIBM.SYSDUMMY1.


Feedback