i hav created a program and moved to production but failed to create the table

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

Question Posted / srprev

3 Answers
5923 Views
UST, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i hav created a program and moved to production but failed to create the table which is been used ..

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

i hav created a program and moved to production but failed to create the table which is been used ..

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

i hav created a program and moved to production but failed to create the table which is been used ..

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

Post New Answer