Page 1 of 1

insertion of null values through a JCL

PostPosted: Tue Dec 11, 2007 4:27 pm
by chinna
Hi,

I need some information about JCL..

How to insert a null values in file through a JCL job ?

Thanks in adavance!!!!

With Regards,

chinna.

Re: insertion of null values through a JCL

PostPosted: Tue Dec 11, 2007 5:23 pm
by MrSpock
What are "null values"?

Re: insertion of null values through a JCL

PostPosted: Tue Dec 11, 2007 5:29 pm
by chinna
Thanks for your replay....

for example.....

In a emplyee record-empno,empname, salary ,deptno.

but i need to insert a null vaues in a empname in total file through a JCL......

Re: insertion of null values through a JCL

PostPosted: Tue Dec 11, 2007 6:57 pm
by William Thompson
chinna wrote:i need to insert a null vaues in a empname in total file through a JCL......
Again, it depends on what tools you have available.....Again, a sort copy with inrec or outrec processing could do what you need.....

Re: insertion of null values through a JCL

PostPosted: Wed Dec 12, 2007 12:26 am
by Frank Yaeger
chinna,

If you want a specific answer, you need to be more specific about what you need to do. What exactly do you mean by null values - binary zeros, blanks, packed decimal zeros, or what? What is the starting position, length and format of the field you want to put nulls in?

As an example, if you wanted to put binary zeros in positions 11-15, you could do it with these DFSORT control statements:

   OPTION COPY
   INREC OVERLAY=(11:5Z)