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
How to find primary key of a table in db2?
What are the uses of db2 optimizer?
Why do chiropractors use drop table?
When reorg is used?
can all users have the privilage to use the sql statement select * (dml)?
What does sqlcabc has?
How do I delete a column in db2?
What is the use of reorg in db2?
What is the physical storage length of the data types date, time, and timestamp?
What is nvl in db2?
What is database alias db2?
What is a buffer in memory?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is host variable?
Which component is responsible for db2 startup and shutdown?