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
- 7063 Views
- UST, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / nitin
If the table is missing then you will get sql code -204.
You will get -204 while binding if you specify the bind
parameter validation(bind) and you will get the -204 at
run time( bind will run sucessfully) if you specify the
bind oparameter as validatin(run).
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
What is db2 command?
How many types of page locks can be held in db2?
What is the use of with ur in db2?
What is the use of dclgen in db2?
Explain about dbrm.
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
What are the advantages of using a PACKAGE?
What is a Database Request Module(DBRM)?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
What is the size of a data page?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
COBOL 
