How do you retrieve the data from a nullable column?
Answer Posted / amol
We have to include one variable in working storage datatype
s9(4).
and while retriveing the value from nullable column we can
give ;host variable :null indicater. If value from column
is found to be null it will stoare in null indicater.
If we have not include the null indicater and value while
fetching found to be null the program will abend with
saqlcode -305.
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
what is db2 restart?
How to check last update on table in db2?
How can you find out the # of rows updated after an update statement?
What is load replace in db2?
What is the purpose of using commit?
Name the various locking levels available?
B37 abend during spufi?
How do I delete a table in db2?
How to retrieve rows from a db2 table in embedded sql?
Is db2 a mainframe?
What is the difference between db2 and oracle?
Is ibm db2 free?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is cursor stability in db2?
Name the lockable units in DB2?