how can u retrieve the data from null values using
applicaion program.
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 are db2 objects?
How can you compare table column after update and before update?
What is a db2 cursor?
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 specific need of Plan and..where are the tables in DB2 are physically saved
What is the function of the Data Manager?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
What is the format (internal layout) of ?TIMESTAMP??
What is a bind card?
max number of columns in a db2 table?
What is a SELECT statement?
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,