Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to convert variable length file to fixed length file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
sridevi2005

New User


Joined: 15 Sep 2005
Posts: 42

PostPosted: Wed Oct 24, 2007 3:27 pm    Post subject: How to convert variable length file to fixed length file
Reply with quote

Hi,


I want to convert VB file to FB file.

I used the following code.

Code:

//STEP1 EXEC  PGM=SORT                                           
//SYSOUT   DD   SYSOUT=*                                         
//SORTIN   DD   DSN=SAS12D.G4662V00.TEST,DISP=SHR
//SORTOUT  DD DSN=GGJ67D.TEST4,                           
//            DISP=(NEW,CATLG,DELETE),                           
//            SPACE=(TRK,(10,10),RLSE),                         
//            RECFM=FB,LRECL=10,DSORG=PS                         
//SYSIN    DD *                                                 
  OPTION VLSHRT                                                 
  SORT FIELDS=COPY                                               
  INCLUDE COND=(89,1,CH,EQ,C'Y',AND,5,3,ZD,EQ,120)               
  OUTREC FIELDS=(8,2,PD,EDIT=(TTTTTTTTTT))               


Its getting abend.

Can anyone help me out.

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

murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Wed Oct 24, 2007 3:29 pm    Post subject:
Reply with quote

Sridevi,

Spool messges please.
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1288
Location: Chennai, India

PostPosted: Wed Oct 24, 2007 3:30 pm    Post subject: Reply to: How to convert variable length file to fixed lengt
Reply with quote

Sridevi,


This has been discussed many times. Search in DFSORT forum for the keyword VTOF.


Post if you still face any issue.
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Wed Oct 24, 2007 3:32 pm    Post subject:
Reply with quote

Sridevi,

I see you had posted earlier on the same issue. Why dont you go thru the below link -


http://ibmmainframes.com/viewtopic.php?t=25393
Back to top
View user's profile Send private message
jmreddymca
Warnings : 1

New User


Joined: 14 Oct 2007
Posts: 29
Location: Bangalore

PostPosted: Wed Oct 24, 2007 3:36 pm    Post subject: hi
Reply with quote

hi sreedevi

check with this it may help you

Code:

//STEP02   EXEC PGM=SORT                       
//SYSOUT   DD SYSOUT=*                         
//SORTIN   DD DSN=vbf,       
//            DISP=SHR                         
//SORTOUT  DD DSN=fixf,       
//            DISP=(NEW,CATLG,DELETE),         
//            SPACE=(TRK,(10,10),RLSE)   
//SYSIN DD *                                       
  SORT FIELDS=COPY                                 
  OUTREC FIELDS= (1:5,150),VTOF                     
/*                                                 
//*
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


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

PostPosted: Wed Oct 24, 2007 9:33 pm    Post subject:
Reply with quote

For more information on DFSORT's VTOF function, see the "VB to FB conversion" Smart DFSORT Trick at:

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 2 Fri Mar 24, 2017 3:25 pm
No new posts splitting a file abdulrafi DFSORT/ICETOOL 4 Fri Mar 24, 2017 11:51 am
No new posts Count the length of the record & ... sreekusr DFSORT/ICETOOL 4 Thu Mar 23, 2017 7:52 pm
No new posts Receive a file using PCOMM macro Harald.v.K IBM Tools 0 Thu Mar 23, 2017 6:50 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us