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 blu acceleration in db2?
What is database reorganization?
What is access path in db2?
what is utility for parm lib
What is null indicator in cobol db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How is deadlock resolved?
i want to maintain uniqueness on pdf without make lf??????????
What is the information associated with sysibm.syslinks table?
What is a cursor in programming?
What is meant by explain?
How to get the ddl of a table in db2?
What do you mean by commit and rollback?
What is commit in db2?
Which components manage deadlocks in db2?