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 package versioning? Please give an example.
if i made sme changes in sub pgm wht r the things to be done for this ?
Which one allows duplicate values Union or Union All ?
What is bind in db2?
What are the Isolation levels possible ?
how to resolve -805. give clear explination for that
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
What is database manager in db2?
can we drop column from a table
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
What is host variable?
What are the 4 environments which can access DB2 ?