Interested to Buy Any Domain ? << Click Here >> for more details...
How do you retrieve the data from a nullable column?
- 2 Answers
- 8704 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
DB2 application must also include a null indicator host
variable along with the host variable to contain the actual
value.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / 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 |
How to rename a table in DB2 ?
Mention data types used in db2 ?
What is the purpose of the WHENEVER statement?
In which column of which DB2 catalog would you find the length of the rows for all tables?
What is a DB2 bind?
What is cursor with hold option in db2?
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
What is ibm db2 connect?
How is the value function used?
What do you mean by between and in? Is between inclusive of specified range values?
Which component is used to execute the sql statements?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
COBOL 
