Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 7361 Views
- UST, I also Faced
- E-Mail Answers
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
Explain about rct in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How do you concatenate the firstname and lastname from emp table to give a complete name?
List some fields from sqlca?
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?
Define check constraint.
What is the difference between nvl and coalesce?
What is the role of union all and union
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
Which command is used to remove all rows from a table?
can we view the access paths created by dbrm ? how ? thx
Are view updateable?
Is ibm db2 free?
Differentiate between cs and rr isolation levels? Where do you specify them?
How many databases are there?
