Interested to Buy Any Domain ? << Click Here >> for more details...
how can u retrieve the data from null values using
applicaion program.
- 3 Answers
- 8619 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / avinash
The null indicator would be assigned a value of -1 if the
fetched column has a null value.
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / prachi
whenever you are retreving the data from null coloumn,
first you need to declare the null indicator in the working
storage section. and use this variable when you are
fecthing the data from null coloumn.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / 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 |
what is static sql? what is dynamic sql? Give me details
What is the significance of DB2 free space and what parameters control it?
What is the size of a data page?
What is the clustering index in the db2 database?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What is db2 optimizer?
What is the purpose of the WHENEVER statement?
can we drop column from a table
How to create backup table in db2?
what is the use of commit ? and what is the syntax?
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
What is cursor?
COBOL 
