Interested to Buy Any Domain ? << Click Here >> for more details...
what is a null indicator in db2?
- 5 Answers
- 22259 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 |
can we modify the code in copy book? if it possible how to submit ofter the modification.
which parameter is used to check the syntax of a jcl without executing it?
hi,i have joined in mainframe course recently. ihave a doubt ragarding restart parameter.what is d use of it. and what is d syntax for it. any one give me d answer pls.
i have job card like this //job ***** //step1 exec pgm=iebgener //sysut1 dd dsn=main.sss,disp=shr // dd dsn=main1.sss,disp=shr // dd dsn=main2.sss,disp=shr //sysut2 dd dsn=out1.mmm ,disp=(new,catlg,delete) dcb=( ) // sysin dd * like this what i have to do to skip dsn=main1.sss please giveme answer asap
What statement can be used to send data to another mvs jes3 node?
Hi, Please clear me when COND=ONLY and COND=EVEN. Explain me with example.
I HAVE A SEQUENTIAL FILE CONTAINING ONE RECORD IN WHICH I HAVE ONE FIELD AS CUSTOMER IDENTITY NUMBER FIELD WHICH IS A SIGNED FIELD. HOW TO SEQUENTIALLY INCREMENT THIS FIELD USING OVERLAY PARAMETER?.
What is the use of ikjeft1b utility in jcl?
What are s0c1, s0c4, s0c5, s0c7 and socb?
what will be the error code if duplicate key of VSAM file is found?
can a job be submitted through jcl only? is there another way to submit a job?
What is DATACOM db?
COBOL 
