DB2 Server for VM: System Administration

Extensions to the Standards

1. VM applications may not use the "userid IDENTIFIED BY password" clause on the CONNECT statement when using the DRDA protocol.
2. Packages that were created in SQLDS protocol by using extended dynamic statements ⁷ cannot be processed in DRDA protocol, or the other way around.
3. There is no support for modifiable packages created by using extended dynamic statements. If you request such support by specifying the MODIFY option on the CREATE PACKAGE statement, the system will override this option with NOMODIFY.
4. Nonmodifiable packages created by using extended dynamic statements are supported with the following restrictions:
   1. There is no support for the positioned UPDATE and positioned DELETE statements.
   2. If the Basic Extended PREPARE form of the extended PREPARE statement prepares a statement that contains parameter markers, the USING DESCRIPTOR clause must be used to identify an input SQLDA structure.
   3. There is no support for the Single Row Extended PREPARE form of the extended PREPARE statement.
   4. There is no support for the NODESCRIBE option of the CREATE PACKAGE statement. If specified, it will be ignored.
   5. There is no support for "USER" in the ISOLATION option of the CREATE PACKAGE statement. The system will override USER with CS.
   6. There is no support for "LOCAL" in the DATE or TIME option of the CREATE PACKAGE statement. If specified, SQLCODE -168 (SQLSTATE 42615) will be generated, indicating an incorrect parameter.
   7. DB2 Server for VSE & VM servers do not support cursors declared with the "WITH HOLD" clause. However, applications may use the "WITH HOLD" clause against other DRDA servers if they support it, except when extended dynamic statements are involved.
5. There is no support for the semantics checking of the Flagger, but the syntax checking of static SQL against the SAA and SQL-89 standards will still be carried out.

⁷

Since DB2 RXSQL uses extended dynamic statements, any restrictions on the use of extended dynamics apply to DB2 RXSQL as well.