Delete a column from a file

In this Mainframe Forum - You can post your queries on JCL, OS/390 JCL, MVS JCL, z/OS JCL, JES2 & JES3

Moderators: Frank Yaeger, DikDude, Moderator Group

Post Reply
archup20
Member
Posts: 31
Joined: Thu Dec 09, 2010 9:53 am

Delete a column from a file

Post by archup20 » Thu Dec 22, 2011 4:28 pm

Hi,

I have data in a flat file from which I have to remove 2 columns of packed decimal first column starts at position 41 and is of length 8 and the second column begins at position 57 and is of length 8.

What should be done in order to delete these 2 columns.

User avatar
Frank Yaeger
Moderator
Posts: 812
Joined: Sat Feb 18, 2006 5:45 am
Location: San Jose, CA
Contact:

Post by Frank Yaeger » Thu Dec 22, 2011 10:39 pm

You can use DFSORT's BUILD to remove columns. For example, if your input file has RECFM=FB and LRECL=80, you can use a DFSORT job like this:

Code: Select all

//S1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=...  input file (FB/80)
//SORTOUT DD DSN=...  output file (FB/64)
//SYSIN DD *
   OPTION COPY
   INREC BUILD=(1,40,49,8,65,16)
If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

http://www.ibm.com/support/docview.wss? ... g3T7000080
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

archup20
Member
Posts: 31
Joined: Thu Dec 09, 2010 9:53 am

Post by archup20 » Fri Dec 23, 2011 2:53 pm

I tried the following variation and it worked fine.

Code: Select all

//SYSIN    DD *           
  SORT FIELDS=COPY        
  OUTREC FIELDS=(1,40,    
                49,8,     
                65,212)   
Thanks :D

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others