How do you retrieve the data from a nullable column?
- 2 Answers
- 8148 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 |
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What are packages in db2?
What does the CHECK Utility do ?
What is a cursor in programming?
What is a bind in db2?
What is index cardinality?
List some fields from sqlca?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
Which are the db2 tools to protect integrity of the database?
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
What is the difference between IN subselects and EXISTS subselect?
COBOL 
