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
Explain how can you do the explain of a dynamic sql statement?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What action db2 takes when a program aborts in the middle of a transaction?
What is the difference between cursor and select statement?
can all users have the privilage to use the sql statement select * (dml)?
What is dpf in db2?
Explain what are the various isolation levels possible?
What is universal database?
Which is faster delete or truncate?
Describe major components of db2?
What is the difference between cursor stability and repeatable read isolation levels?
What is null indicator in db2?
What is the syntax for creating a table in the db2 database?
List out the buffer pools in db2
What is runstats and reorg in db2?