IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Crop Variable Block file, header and trailer intact


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Manu Dhawan

New User


Joined: 01 Jun 2009
Posts: 9
Location: India

PostPosted: Tue Jul 28, 2009 3:45 pm
Reply with quote

Hi,

I need to crop a VB file where I need to delete some columns, but the header and trailer record should not be changed in the output file. The trailer record can be identified using a key and header is always the first record. Is it possible in Sort?

I try to explain by example(Input and output are VB file):-

Input File:-

123456789HEADER
123456789RECORD1
123456789RECORD2
123456789RECORD3
.............................
.............................
123456789RECORDn
123456789TRAILER

Let say I need to detele columns 4 to 9.

Output File required as:-

123456789HEADER
123RECORD1
123RECORD2
123RECORD3
.............................
.............................
123RECORDn
123456789TRAILER

Thanks,
Manu
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Tue Jul 28, 2009 3:54 pm
Reply with quote

Take a look at the DFSORT tricks book HERE
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Tue Jul 28, 2009 9:00 pm
Reply with quote

Manu,

You can use a DFSORT job like the following to do what you asked for:

Code:

//S1    EXEC  PGM=SORT
//SYSOUT    DD  SYSOUT=*
//SORTIN DD DSN=...  input file (VB)
//SORTOUT DD DSN=...  output file (VB)
//SYSIN    DD    *
  OPTION COPY
  INREC IFTHEN=(WHEN=(14,6,CH,NE,C'HEADER',
     AND,14,7,CH,NE,C'TRAILER'),
    BUILD=(1,7,14))
/*
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
Search our Forums:

Back to Top