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
- 7190 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 are the 4 environments which can access DB2 ?
What do you mean by commit and rollback?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
What is the purpose of the DSNC transaction ?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
What is syscat in db2?
What is innodb buffer pool?
How to update more then one record using update?
What is the use of value function?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
What is concurrency in db2?
COBOL 
