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
- 7264 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 |
Explain about rct in db2?
Can you define an Index if the table size less than 10 PAGES?
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
What do you mean by cursor?
Highlight all the advantages that are attached to a package.
What is a clustering index ?
What information can you find in SYSIBM.SYSLINKS table?
what is differnece between DROP TABLE & DELETE TABLE .
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
What is the usage of open cursor command?
Where are plans stored?
COBOL 
