i hav created a program and moved to production but failed
to create the table which is been used in the program. the
program shows error as soon as it is moved or installed in
production or shows error during its runtime. what is the
sqlcode for this error
Answer Posted / mahesh
it will Abend with SQLCODE=-922(Authoriziation issue); as
while promotion to production ; it wont allow the tables
created in test region.
Please correct me if i am wrong ?
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
Comment whether the cursor is closed during commit or not.
What is the clustering index in the db2 database?
What is load replace in db2?
What is a trigger in the db2 database?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is buffer pool and list some of them?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is a db2 tablespace?
What is page size in db2?
Outputs of explain are with matchcols = 0. What does this signify?
What is runstats db2?
How to restart a DB2 program?
Which component is responsible for processing sql statements and selecting access paths?
Is db2 a database?
what is db2 restart?