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



WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?..

Answer / mr. cooooool

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

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?..

Answer / nans

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

Post New Answer

More DB2 Interview Questions

What is database manager in db2?

0 Answers  


What is a plan and package in db2?

0 Answers  


What is db2? Explain.

0 Answers  


What happens to the PLAN if index used by it is dropped?

1 Answers  


Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,






what is parm utility

2 Answers   IBM,


Which components manage deadlocks in db2?

0 Answers  


What Utility is used to migrate DB2 from one release to the next?

1 Answers  


What are catalog tables in db2?

0 Answers  


What is pagespace?

1 Answers  


what is the difference between where clause and having clause

2 Answers   IBM,


How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,


Categories