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
- 7371 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 MEANT BY COMMIT COMMAND?
What is the difference between TYPE 1 index & TYPE 2 index
What is REORG? When is it used?
What is meant by AUTO COMMIT?
how to resolve -818 error. how to see timestamp token in load module and plan
What are bind parameters in db2?
What is the difference between Primary key and unique index?
What does DML stand for and what are some examples of it?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
What is the difference between SYNONYM and ALIAS?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
COBOL 
