insertion of null values through a JCL

JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...
chinna
Posts: 4
Joined: Tue Dec 11, 2007 4:13 pm
Skillset: cobol,jcl,db2,pl/1,ims,cics
Referer: google

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.

User avatar
MrSpock
Global moderator
Posts: 809
Joined: Wed Jun 06, 2007 9:37 pm
Skillset: REXX, JCL, DFSORT, Syncsort, Axway MFT, Connect:Direct, FTP, SFTP
Referer: ibmmainframes.com
Location: Raleigh NC USA
Contact:

Re: insertion of null values through a JCL

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

What are "null values"?

chinna
Posts: 4
Joined: Tue Dec 11, 2007 4:13 pm
Skillset: cobol,jcl,db2,pl/1,ims,cics
Referer: google

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

William Thompson
Posts: 81
Joined: Sat Jun 09, 2007 4:24 am
Skillset: Some?
Referer: mcmillan
Location: Tucson AZ

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

User avatar
Frank Yaeger
Global moderator
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Skillset: DFSORT, ICETOOL, ICEGENER
Referer: Search
Contact:

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:

Code: Select all

   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