Truncate the lst colums



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Truncate the lst colums

Postby samb01 » Mon Nov 16, 2009 7:32 pm

I've a dataset VB 290 (LRECL) ==> IN

and I want a dataset with VB 255 (LRECL) ==> OUT

Is it possible to truncate the last 35 columns of then first dataset?
samb01
 
Posts: 236
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Truncate the lst colums

 

Re: Truncate the lst colums

Postby Frank Yaeger » Mon Nov 16, 2009 11:42 pm

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

//S1    EXEC  PGM=SORT
//SYSOUT    DD  SYSOUT=*
//SORTIN DD DSN=...  input file (VB/290)
//SORTOUT DD LRECL=255,DSN=...  output file (VB/255)
//SYSIN    DD    *
  OPTION COPY,VLLONG
/*
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
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

Re: Truncate the lst colums

Postby samb01 » Tue Nov 17, 2009 5:08 pm

Thanks !

Is Works !
samb01
 
Posts: 236
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER