When operating in NPS compatibility mode, which of the following are limitations for using a routine written in NZPLSQL? (Choose two.)
When operating in NPS compatibility mode, which of the following are limitations for using a routine written in NZPLSQL? (Choose two.)
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.
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