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.
insertion of null values through a JCL
- 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
What are "null values"?
-
- 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
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......
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......
-
- 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
Again, it depends on what tools you have available.....Again, a sort copy with inrec or outrec processing could do what you need.....chinna wrote:i need to insert a null vaues in a empname in total file through a JCL......
- 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
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:
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
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort