VALUES statements

DB2® Database for Linux®, UNIX®, and Windows® cannot run statically the form of the VALUES statement that it supports running dynamically. Moreover, it cannot run dynamically the form of the VALUES statement that it supports running statically.

In JDBC, your application might use the VALUES statement like a SELECT statement against SYSIBM.SYSDUMMY1. To overcome the restriction in DB2 Database for Linux, UNIX, and Windows, rewrite any VALUES statement as a SELECT FROM SYSIBM.SYSDUMMY1.


Feedback