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 / andank
The code promotion will fail. When you promote the code
from one region to other (say QC to Production), the
program will be bound (BIND) to the new DB2 environment.
The BIND will fail with SQLCODE of -204 (Object Not found).
The code will not be moved to production successfully and
there is no chance of 'runtime' error.
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
What is multi row fetch in db2?
Why do we need reorg in db2?
What is the purpose of rollback and commit?
List out the three types of page locks that can be held.
What is the use of reorg in db2?
Explain in brief how does db2 determine what lock-size to use?
Why do chiropractors use drop table?
What is a collection in db2?
What is the difference between dbm cfg and db cfg file in db2 ?
What are the 2 sqlcodes that are returned?
What is runstats utility in db2?
What is precompiler in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
What do you mean by commit and rollback?
What are host variables in db2?