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 How to change 'K' or 'M' use Sort vice_versa DFSORT/ICETOOL 5 Thu May 18, 2017 7:11 am
No new posts Using ICETOOL, how we can seperate th... bshkris SYNCSORT 5 Tue May 09, 2017 8:33 pm
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
This topic is locked: you cannot edit posts or make replies. SORT trick needed bshkris SYNCSORT 6 Tue May 02, 2017 4:35 am
No new posts SORT JSON type of data maxsubrat DFSORT/ICETOOL 8 Wed Apr 19, 2017 6:01 pm


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