Interested to Buy Any Domain ? << Click Here >> for more details...
what is a null indicator in db2?
- 5 Answers
- 22050 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 |
We have two PS files,want to compare those files and put the duplicate records in one file. Input file 1 contains(1,2,4,9,10) Input file 2 contains (1,4,5,11,12,14,16). Help me with jcl.
i want apply mainframe devolper with 3+ but i dont have that much of knowledge what isthe solution to get that much of knoweldge?
Explain about RECORDING MODE Clause
What is DYNAMBR in jcl?
what do you mean by include statement in jcl?
can any one plzzzzzz tell the jcl code for creating ps using idcams
When we use conditional statement in JCL using if-then-else-endif, IF statement is true, the step is bypassed or executed?
If a (+1) generation dataset is created in the first step of a job, how can it be referenced in later steps of the same job for input?
What is the difference between run mode and addressing mode?
How to fetch even records from one file to another file by using ICETOOL in JCL?
We are aware of eliminating the duplicate records from outyput fiel using sort utility. Can we get the duplicate records in to another file in the Same sort utility?
What is RESTART? How is it invoked?
COBOL 
