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.

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.

Answer / chiru the master

-1 is the null indicator

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...

Answer / shaik

Null is unknown information (garbage)

Explain the purpose of dd * statement in jcl?

0 Answers  

What are the parameter we cannot use in procedure?

0 Answers  

How are GDGs concatenated?

1 Answers  

AM HAVING A FILE WHICH CONTAIN 12 DATS OUT OF WHICH 4 ARE DUPLICATES HOW TO REMOVE THE DUPLICATE FILES IN JCL? CAN I GET THE PROGRAM FOR THIS

3 Answers  

if we compile the cobol+ db2 program now ofter 5 years we need to compile again?

1 Answers   TCS,

In My job I have 15 procs.and in each proc i have 3 steps. i want to execute 3 step in proc 10.is it possible? if possible how?

2 Answers   HP,

In sms datasets, what is the function of the dd mgmtclas keyword?

0 Answers  

How do you find which GDG is using which dataset?

3 Answers   Patni,

hi iam learning mainframes,can anybody tell me how to check JCL errors.(after submiting the JCL we have check in spool or is there any other method)

8 Answers  

How do you skip a particular step in a proc/JOB?

5 Answers   CSC, CTS,

At what stage, operator can change the class and priority of a submitted job?

2 Answers  

I have a COBOL program that ACCEPTs some input data. How do you code the JCL statement for this?

0 Answers