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)

I have Job A and Job B. I want to trigger Job B from Job A. Please advise.

2 Answers   Wipro,

How to compare two files in SYNCSORT and on the mismatch record should be deleted from second file.

0 Answers   CSC, SPIC,

Explain how can values be passed from the job stream to an executable program?

0 Answers  

What is GDG and what is the maximum limit of versions that can be created?

9 Answers   Convergys,

what will be the error code if duplicate key of VSAM file is found?

1 Answers   HSBC, Kings,

What is the difference between specifying DISP=OLD and DISP=SHR for a dataset?

2 Answers  

How Can we see all generations of a GDG ?

3 Answers   Polaris,

how to allocate a dynamic dataset in jcl ?

3 Answers   Patni, TCS,

What are the default system and catalog libraries in JCL?

2 Answers   Infosys,

what is A-MODE and R-MODE?

2 Answers  

There is one QSAM is the VB file. i want to get the first characters in this file and change those characters from'abcd' to '1234' and creat a vasm file to put '1234' in it. how to do in only JCL. if it not QSAM, it's VASM and VB. how to do it.

1 Answers   IBM,

How to submit a jcl from cics?

0 Answers