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 the maximum No of rows per page?
What is db2? Explain.
How many databases are there?
What is dbrm? What it contains? When it will be created?
What type of database is db2?
What are the 2 sqlcodes that are returned?
What is a db2 cursor?
what is db2 restart?
What is a db2 collection?
What do you mean by storage group (stogroup)?
How can we read records for specific member in CL? AND rpg?
What is the use of predicate?
How can you classify the locks in db2?
Explain correlated sub-queries.
How does cobol compile db2 program?