MVSFORUMS.com

sivafdms · Intermediate Joined: 29 May 2007 Posts: 165 Topics: 77

Hi,

I want to omit some of the columns from input file while copying.

Example..

Input file(80/vb)

Frank Yaeger · Posted: Wed May 07, 2008 1:16 pm Post subject:

Assuming the Name field is 9 bytes long and the Designation field starts at position 25 (29 if you count the RDW) in the input file, you can use a DFSORT job like this to do what you asked for:

sivafdms · Intermediate Joined: 29 May 2007 Posts: 165 Topics: 77

Frank,

If you can tell what is RDW it would be a great help

Thanks,
Siva

Frank Yaeger · Posted: Wed May 07, 2008 2:58 pm Post subject:

RDW = record descriptor word. For a RECFM=V (VB, etc) file, the RDW occupies the first 4 bytes of the record. The first two bytes contains the length of the record including the RDW itself in binary. The next two bytes contain binary zeros. The first data byte starts in the fifth byte of the record after the RDW.

If you're going to be working with data sets on z/OS, you might want to familiarize yourself with the information in "z/OS Using Data Sets" at:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DGT2D460/CCONTENTS?SHELF=EZ2ZO10J&DN=SC26-7410-07&DT=20070711232714

Here's the description of an RDW in that book:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DGT2D460/3.1.3.1.2?SHELF=EZ2ZO10J&DT=20070711232714&CASE=
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort