Exam C2090-600 All QuestionsBrowse all questions from this exam
Question 21

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

    Correct Answer: B, D

    When operating in NPS compatibility mode, a routine written in NZPLSQL has specific limitations. The routine must return either an integer or a null, ensuring that the return type is strictly defined. Additionally, the routine cannot contain argument lists or variable arguments (varargs), limiting the flexibility in defining input parameters. These constraints are essential to maintain proper function and compatibility with the system's requirements.

Discussion
db2testerOptions: BD

The below answers are correct B. The routine must return either an integer or a null. D. The routine cannot contain argument lists or variable arguments (varargs). The correct reference is https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.porting.doc/doc/r_sql_compat_nzplsql_limitations.html