Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Help: Extracting some fields from VB to FB

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

New User


Joined: 03 Oct 2005
Posts: 10

PostPosted: Tue May 02, 2006 1:19 am    Post subject: Help: Extracting some fields from VB to FB
Reply with quote

Hi,

I used SORT to extract some columns from a VB file to an FB file. I get following error message.

ICE043A 3 INVALID DATA SET ATTRIBUTES SPECIFIED SORTOUT RECFM

Can someone please tell me if there is a way to copy from VB to FB like how I have tried below?

Your help is appreciated,
Yuvaraj

The SORT step is pasted below -

//EXTRACT EXEC PGM=SORT,REGION=1M
//SYSPRINT DD SYSOUT=*
//SYSABEND DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=ISDXYXN.SCON00P.GB.BCOAZ34D.AMF.G0053,
// DISP=SHR
//SORTOUT DD DSN=ISDXYXN.SCON00P.GB.BCOAZ34D.AMF.G0053.EXT,
// DISP=(NEW,CATLG,DELETE),
// DATACLAS=SMALL,
// DCB=(RECFM=FB,LRECL=16)
//SYSIN DD *
SORT FIELDS=COPY
OUTREC FIELDS=(5,9,PD,M0)
/*
Back to top
View user's profile Send private message

yuvaraj80

New User


Joined: 03 Oct 2005
Posts: 10

PostPosted: Tue May 02, 2006 1:42 am    Post subject: ....got a work around..
Reply with quote

Guys,

I got it done. Used CONVERT statement with OUTFIL OUTREC. It worked.

Thanks for all those who tried to help me.

Find the SORT step below -

Code:

//EXTRACT EXEC  PGM=SORT,REGION=1M                           
//SYSOUT   DD  SYSOUT=*                                       
//SORTIN   DD  DSN=ISDXYXN.SCON00P.GB.BCOAZ34D.AMF.G0053,     
//             DISP=SHR                                       
//SORTOUT  DD  DSN=ISDXYXN.SCON00P.GB.BCOAZ34D.AMF.G0053.EXT,
//             DISP=(NEW,CATLG,DELETE),                       
//             DATACLAS=SMALL,                               
//             DCB=(RECFM=FB,LRECL=18)                       
//SYSIN     DD *                                             
  SORT FIELDS=COPY                                             
  OUTFIL OUTREC=(5,9,PD,M0),CONVERT
/*
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: Tue May 02, 2006 2:11 am    Post subject:
Reply with quote

Right. See the following Smart DFSORT Tricks for more information on converting from VB to FB and from FB to VB:

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/srtmst01.html#t11

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/srtmst03.html#t09

Note that you don't need:

// DCB=(RECFM=FB,LRECL=18)

DFSORT will set it automatically.
Back to top
View user's profile Send private message
yuvaraj80

New User


Joined: 03 Oct 2005
Posts: 10

PostPosted: Tue May 02, 2006 2:20 am    Post subject: thx...I browsed the link that you provided...
Reply with quote

thx...I browsed the link that you provided...
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 Subtract the ZD fields to provide neg... Balaryan DFSORT/ICETOOL 4 Wed Oct 11, 2017 10:51 pm
No new posts Addition of two records on 2 fields amar143 SYNCSORT 8 Tue Oct 03, 2017 11:14 am
No new posts Split file based on comparsion to 2 f... Div Grad DFSORT/ICETOOL 3 Thu Jul 27, 2017 9:16 pm
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Validate date and numeric fields and ... Rick Silvers DFSORT/ICETOOL 6 Thu May 11, 2017 6:51 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us