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

How do you select a row using indexes in db2?

0 Answers  


What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,


What is a thread?

3 Answers  


What are the uses of db2 optimizer?

0 Answers  


What is a clustered index?

1 Answers  






List down the types of triggers in the db2 database?

0 Answers  


What is meant by AUTO COMMIT?

3 Answers  


what is datacom db?

2 Answers   CSC,


What is filter factor?

2 Answers  


How do I optimize a query in db2?

0 Answers  


wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,


How can you do the explain of a dynamic sql statement?

0 Answers  


Categories