IBM
C2090-320 · Question #34
A stored procedure needs to issue a dynamic SQL statement (SELECT) at runtime. The stored procedure's owner ID must be used for the authorization check (whether or not the SELECT is allowed). Which…
The correct answer is A. DYNAMICRULES(RUN). eproceduresqlnative.html
Data Quality Rules and Analysis
Question
A stored procedure needs to issue a dynamic SQL statement (SELECT) at runtime. The stored procedure's owner ID must be used for the authorization check (whether or not the SELECT is allowed). Which BIND parameter setting can you use to accomplish this?
Options
- ADYNAMICRULES(RUN)
- BDYNAMICRULES(BIND)
- CDYNAMICRULES(INVOKERUN)
- DDYNAMICRULES(DEFINEBIND)
How the community answered
(27 responses)- A78% (21)
- B4% (1)
- C4% (1)
- D15% (4)
Explanation
eproceduresqlnative.html
Topics
#DYNAMICRULES#dynamic SQL authorization#stored procedure#BIND parameter
Community Discussion
No community discussion yet for this question.