how can u retrieve the data from null values using
applicaion program.
Answer Posted / bhavani
When we retrieve data from a nullable field, we need to
have a null indicator declared in the working storage.
WS-NULL-INDICATOR s9(04) comp
And after you have fetched the value for that column,
we need to check the value of the null indicator.
It can have the following values
-2 - Exceptional condition
-1 - Null Value is present in that field
0 - Not null
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is a db2 collection?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is the use of dclgen in db2?
What are the contents of dclgen?
What does runstats do in db2?
Explain about dbrm.
How connect db2 database to datastage?
What is cloudant database?
What is reorg?
What is an instance database?
Define sqlca.
What's The Error Code For Unique Index Voilation?
What is dbrm? When it will be created?
How and when does the db2 enforces the unique key?
What is nvl in db2?