Interested to Buy Any Domain ? << Click Here >> for more details...
how can u retrieve the data from null values using
applicaion program.
- 3 Answers
- 8589 Views
- TCS, I also Faced
- E-Mail Answers
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 cursor in dbms?
What is the maximum size of varchar data type in db2?
Give a brief description of db2 isolation levels?
What is a Foreign Key?
Why do we need reorg in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What are the full forms of spufi and dclgen and why are they used?
What is the use of db2 optimizer?
Mention the definition of cobol in varchar field.
Mention the different locking levels that are available in db2.
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?
How can we retrieve the total number of records in RPG & CLLE?
How can record locking be achieved in those DB2 versions which do not support it?
What is the maximum number of columns in a db2 table?
Name the various locking levels available?
