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)

How to change default PROCLIB?

1 Answers  

Is it possiable to use a gdg in the INCLUDE statement in a SORT jcl? I am using this because I want to change the condition with out changing the jcl. Please provide with a sample code.

1 Answers  

While using SORT FILES =NONE,XSUM I am getting error "ICE172A E XSUM IS NOT SUPPORTED - USE ICETOOL SELECT IF APPROPRIATE"..I want to write duplicate records a a serparte file..how i can do tht?

3 Answers   Steria,

what is the meaning of keyword in jcl?what is is opposite?

4 Answers  

i have a jcl containing header body and trailer .in header i have viswa body 2 6 1 9 7 trailer reddy .now i need to sort only body in either asecending or descending order how can i do it

1 Answers   L&T,

what is JCL?

0 Answers  

Explain how can the attributes of one sms dataset be copied to another dataset?

0 Answers  

What are the parameters that are used in creating a gdg?

0 Answers  

What are the differences between JES2 & JES3 ?

4 Answers  

i have a file which contains duplicates ? my requirement is to eliminate duplicates and these elminated duplicates should be moved to another file can any code this using sort ?

3 Answers   IBM,

what is the use of temporary files?

5 Answers   Hexaware,

Say I have a file with 12 records. Each record has the name of the month. I have to append data in these 12 records into 1 record. How is it possible?

2 Answers   CTS,