what is a null indicator in db2?
- 5 Answers
- 20057 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 is the job entry system used in your project? based on what criteria the sequence of jobs are picked if priority is not mentioned in the job card?
how can i code cond parameter in procedures ? i have a jclk calling a proc which has 10 steps i want to execute from step 5 to step 10 where can i code restrat parameter or cond parameter for ths
what is d/f b/w sysout & sysprint
Explain about User Information
Does jcl support automatic restart?
What is the function of job statement in jcl?
What is GDG?
How to find out the number of records in a file using JCL
Can comments be specified at the very beginning of a jobcard? Will the JCL execute?
How to Enter The Spool Area In Real Time?
Current version of GDG is ID.GDG.FILE.G0001V00. JCL has procedure with 2 steps like below, What will be the output file name in each step ? PROC starts Step 1 has ID.GDG.FILE(+1) Step2 has ID.GDG.FILE(+4) PEND Similarly, JCL has 2 steps in 2 separate procedure. What will be the output file names here ? PROC starts Step 1 has ID.GDG.FILE(+1) PEND PROC1 starts Step2 has ID.GDG.FILE(+4) PEND
How many types we can give input to JCL
COBOL 
