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
 

 

Can ICETOOL SORT from VB to FB?

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

New User


Joined: 19 May 2007
Posts: 5
Location: Toronto, Ontario

PostPosted: Sun Nov 09, 2008 12:57 am    Post subject: Can ICETOOL SORT from VB to FB?
Reply with quote

I have a VB dataset I want to sort into FB using OUTREC= .

However I get the following error:
ICE043A K INVALID DATA SET ATTRIBUTES SPECIFIED SORTOUT RECFM

Here is the exact JCL (notice the output should be comprise of 6 + 3 + 77 = 86 bytes) :

Code:
//SORT     EXEC PGM=ICETOOL
//TOOLMSG  DD SYSOUT=*
//DFSMSG   DD SYSOUT=*
//IN       DD DISP=SHR,DSN=TCCV.GBL9.PVT
//SORTOUT  DD DSN=TCCV.GBL9.PVT.SORT,DISP=(,CATLG,CATLG),
//         UNIT=DISK,SPACE=(CYL,(99,99),RLSE),
//         DCB=(RECFM=FB,LRECL=86,BLKSIZE=8600)
//SYSOUT   DD SYSOUT=*
//TOOLIN   DD *
  SORT FROM(IN) TO(SORTOUT) USING(INCL)
//INCLCNTL DD *
  INCLUDE COND=(074,003,CH,EQ,C'MTC',OR,
                074,003,CH,EQ,C'HOF',OR,
                074,003,CH,EQ,C'PRV')
  SORT FIELDS=(074,003,CH,A)
  OUTREC FIELDS=(074,006,318,003,328,077)
//


"Code"ed for readability. . .
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Nov 09, 2008 1:57 am    Post subject:
Reply with quote

Hello,

You'll want to use VTOF. Also, i'm not sure that your "outrec" is what you want.

Look at this previous topic:
http://ibmmainframes.com/viewtopic.php?t=29046
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: Sun Nov 09, 2008 5:45 am    Post subject:
Reply with quote

Jason,

Here's a DFSORT/ICETOOL job that will do what you asked for. I assumed you counted the RDW in positions 1-4 when determining your starting positions (the first data byte starts in position 5 for a VB record). If not, then increase each starting position by 4 (e.g. 74+4 = 78).

Code:

//SORT     EXEC PGM=ICETOOL
//TOOLMSG  DD SYSOUT=*
//DFSMSG   DD SYSOUT=*
//IN       DD DSN=&&IN,DISP=(OLD,PASS)
//SORTOUT DD DSN=&&O1,UNIT=SYSDA,SPACE=(CYL,(5,5)),DISP=(,PASS),
//         DCB=(RECFM=FB,LRECL=86,BLKSIZE=8600)
//TOOLIN   DD *
SORT FROM(IN) USING(INCL)
/*
//INCLCNTL DD *
  INCLUDE COND=(074,003,CH,EQ,C'MTC',OR,
                074,003,CH,EQ,C'HOF',OR,
                074,003,CH,EQ,C'PRV')
  SORT FIELDS=(074,003,CH,A)
  OUTFIL FNAMES=SORTOUT,VTOF,
    BUILD=(74,6,318,3,328,77)
/*
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 SORT to unpack a feild shr_amar DFSORT/ICETOOL 7 Fri Jul 07, 2017 4:32 am
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Optimize sort inrec parse vishwakotin DFSORT/ICETOOL 6 Mon Jun 26, 2017 11:15 pm
No new posts Reduce CPU Times for Join Sort santoshn SYNCSORT 12 Sat Jun 10, 2017 1:40 pm
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm


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