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
- 6245 Views
- UST, I also Faced
- E-Mail Answers
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
How to retrieve rows from a db2 table in embedded sql?
What action db2 takes when a program aborts in the middle of a transaction?
What are the various isolation levels possible?
When reorg is used?
Which component is responsible for processing sql statements and selecting access paths?
What is coalesce in db2?
How can you do the explain of a dynamic sql statement?
What are the benefits of using the db2 database?
Name the lockable units in DB2?
What is database alias db2?
Which isolation level provides highest data integrity?
Can you use max on a char column?
What is table space in db2?
How to get the ddl of a table in db2?
How do I create a view in db2?
