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 does DML stand for and what are some examples of it?
What are the 2 sqlcodes that are returned?
What is phantom read in db2?
i want to delete 20th million record how ?
What is IMAGECOPY ?
Name the various locking levels available?
Can there be more than one cursor open for any program?
What is a db2 table?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
What is an access path?
What is the use of runstats in db2?
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?