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
- 5986 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 |
Name the lockable units in DB2?
How could one combine a set of incremental image copies into a single copy?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
How many clustering indexes can be defined for a table?
define clustering index.
What does sqlcabc has?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
When reorg is used?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
How do I start db2 in windows?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
How does DB2 store NULL physically?
COBOL 
