WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS
USED IN FILES CONCEPT? HOW DO WE USE IT?
Answers were Sorted based on User's Feedback
We use Null Indicator to fetch the Null Values from the
database through the application Program.
If we don't mention Null Indictor, in that case Null Values will not be retrieved by application program.
THANKS
| Is This Answer Correct ? | 1 Yes | 0 No |
NULL indicator specifically used to find the value is present
or not in Table. For PRIMARY key the value should present.
When working with this key in program, there may be chance of
no value is present/value truncated. In such cases, NULL
indicator is used.
In file NULL indicator cannot be used.
| Is This Answer Correct ? | 0 Yes | 1 No |
what is the difference between normal select query and currosor
Give a brief description of db2 isolation levels?
What is view db2?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
What is performance tuning db2?
How can we retrieve the total number of records in RPG & CLLE?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
what is SMP/E? and what are the major steps of it? thanks...
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
select 100 records from million records ?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
How can record locking be achieved in those DB2 versions which do not support it?