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 maximum number of tables that can be joined ?
What do you need to do before you do EXPLAIN?
How can you compare table column after update and before update?
What is the reason behind not using select * in embedded sql programs?
What is cursor with hold option in db2?
What is an instance in db2?
Explain the contention situations caused by locks?
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
What is the role of the data page in the db2 database?
what is the use of bind parameter, Replace?
What is package in db2 mainframe?
When is the results table for the query in a DECLARE CURSOR statement created?