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
List down the types of triggers in the db2 database?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is the use of value function?
What is database alias db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Why do we use cursor?
What is a db2 schema?
What does reorg do in db2?
Is db2 relational database?
What is rct?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is the result of open cursor statement?
What is cursor with hold option in db2?
What is catalog database in db2?
Define declaration generator (dclgen).