insertion of null values through a JCL



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

insertion of null values through a JCL

Postby chinna » Tue Dec 11, 2007 4:27 pm

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.
chinna
 
Posts: 4
Joined: Tue Dec 11, 2007 4:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: insertion of null values through a JCL

 

Re: insertion of null values through a JCL

Postby MrSpock » Tue Dec 11, 2007 5:23 pm

What are "null values"?
User avatar
MrSpock
Global moderator
 
Posts: 810
Joined: Wed Jun 06, 2007 9:37 pm
Location: Raleigh NC USA
Has thanked: 0 time
Been thanked: 2 times

Re: insertion of null values through a JCL

Postby chinna » Tue Dec 11, 2007 5:29 pm

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......
chinna
 
Posts: 4
Joined: Tue Dec 11, 2007 4:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: insertion of null values through a JCL

Postby William Thompson » Tue Dec 11, 2007 6:57 pm

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.....
William Thompson
 
Posts: 86
Joined: Sat Jun 09, 2007 4:24 am
Location: Tucson AZ
Has thanked: 0 time
Been thanked: 1 time

Re: insertion of null values through a JCL

Postby Frank Yaeger » Wed Dec 12, 2007 12:26 am

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)
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post