DB2 10 for z/OS Database Administrator — Question 21

When operating in NPS compatibility mode, which of the following are limitations for using a routine written in NZPLSQL? (Choose two.)

Answer options

• A. The routine cannot contain comments.
• B. The routine must return either an integer or a null.
• C. The routine must be cross-compatible with Oracle PL/SQL syntax rules.
• D. The routine cannot contain argument lists or variable arguments (varargs).
• E. The routine must be generated with IBM Database Conversion Workbench (DCW).

Correct answer: B, D

Explanation

The correct answers are B and D because, in NPS compatibility mode, routines must return either an integer or null, and they cannot have argument lists or variable arguments. Options A, C, and E do not accurately reflect the limitations imposed by NPS compatibility mode on NZPLSQL routines.