what is a null indicator in db2?
- 5 Answers
- 20520 Views
- Fiserv, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Hi,
Suppose if the database table has a couloumn empno, it may
or may not null.
to handle these type of values we have to use null
indicator.
It indicates that particular coloumn may contain null
values likewise.
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / shaik
If the Resultant Table value is nulls(Garbage) then
Embedded SQL abends with the SQLCODE -305, even we can
handle this to not abend, but we cann't move the garbage to
target value, so, before moving the data to target field,
we need to make sure whether it has nulls or not, we can
identify the feild holds null or not by checking the Null
indicator(Ned to define with half-ward binary format in ws
section) value with < = 0. if less than then null
available, if 0 then nulls not available. Generally id
nulls are available, we will initializa the value then we
will move this to target.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / poornima.t
NULL INDICATOR IS USED TO FIND OUT WHETHER
THE COLUMN IN THE TABLE IS NULL OR NOT NULL...
IN COLUMN IF THE VALUE IS NOT SPECIFIED THEN IT IS
TREATED AS NULL VALUE...
| Is This Answer Correct ? | 0 Yes | 0 No |
What dd statement is used to supply the name of a dataset?
How to print data of sequential file to Spool..?
Why do you use a control card?
what is mainframe?
A job has 150 steps i want to execute only 57th step
Explain the function of the dd dcb keyword?
what is inrec fields and outrec fields in sorting
What parameter of the job statement is used to limit the cpu time consumed by the job?
Can we able insert data into a PS file Using IEBUPDTE utility??? If Yes can anyone describe it please..
What is a procedure?
if in a job, region is mentioned in both jobcard and in step then which is cosidered at the step level? A job has region 4k in jobcard and step1 with region 0k and step2 with 16k, then what is the region allocated for the entire job? what is the region step1 takes? what is the region step2 takes?
How to code these statements in JCL: CLEANUP INITIAL(NO) RESTART(NO) DYNALLOC(NO) job definition..?
COBOL 
