Interested to Buy Any Domain ? << Click Here >> for more details...
How do you retrieve the data from a nullable column?
- 2 Answers
- 8812 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 |
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
How can record locking be achieved in those DB2 versions which do not support it?
What is database alias db2?
Explain what a plan is?
pls tell me abt the normalization five types....
What do you mean by NOT NULL? When will you use it?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is the difference between Where and Having Clause
What can the SET option of the Repair Utility accomplish?
What is EXPLAIN?
What is the difference between IN subselects and EXISTS subselect?
COBOL 
