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 primary key & unique index ?
What is a predicate?
How to find the maximum value in a column in the db2 database?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
What will the FREE command do to a plan?
Can you access the DB2 Directory table using SQL?
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
What can the SET option of the Repair Utility accomplish?
What is load replace in db2?
Explain about rct in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What if we fail to give values in columns declared as NOT NULL ?