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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I add a column to a table in db2?

709


How many types of page locks can be held in db2?

687


What is the role of union all and union

727


What is a dbrm in db2?

660


Can we delete records from view?

651






How do I delete a table in database?

689


What is the maximum No of rows per page?

708


Can we insert update delete in view?

659


Explain about cursor stability?

696


What is the latest version of ibm db2?

826


How to get the ddl of a table in db2?

758


what is db2 restart?

1778


What is cascading rollback?

711


What is db2 connect?

691


Which is faster delete or truncate?

766