Interested to Buy Any Domain ? << Click Here >> for more details...
How do you retrieve the data from a nullable column?
- 2 Answers
- 8910 Views
- I also Faced
- E-Mail Answers
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 syntax for creating a table in the db2 database?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Define check constraint.
Discuss about db2 bind?
can we view the access paths created by dbrm ? how ? thx
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How do we specify index to include or not during bind process.
How is deadlock resolved?
What is difference between rollback and commit?
What is a page in db2?
Is db2 a mainframe?
What are types of indexes?
What is check constraint. Explain with example.
How to restart a DB2 program?
What is db2 optimizer?
