WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS
USED IN FILES CONCEPT? HOW DO WE USE IT?
- 2 Answers
- 6194 Views
- IBM, I also Faced
- E-Mail Answers
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 cursor and select statement?
What is the size of a data page?
What is the use of predicate?
what is cursor stability?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
What is a view? Why use it?
can i code union in cobol-db2 pgm ?
How do you check for a null value in a db2 column?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
What is the difference between plan and package in db2?
Can we use select * statement in cobol program without giving field names ???
COBOL 
