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
 

 

Issue with ICETOOL

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

New User


Joined: 12 Dec 2005
Posts: 13

PostPosted: Mon Mar 22, 2010 5:06 pm    Post subject: Issue with ICETOOL
Reply with quote

Hi Frank,

I having two input files. One input is having record length 80 of type FB. Second file is having Record length as 27162 of type FB.

Key value from the input file 1 : Start position 1 and length is 7.
Key value from the input file 2 : Start position 2 and length is 7.

I want to compare File 1 and File 2 based on Key value. If the record is available in the both file I want the Second file record in the Output file.

My system does not support SYNC SORT and SYNC TOOL. I am trying SPLICE option in ICETOOL but not successful.

SYNTAX form SYNC SORT is:

SORT FIELDS=COPY
JOINKEYS FILE=F1,FIELDS=(1,7,A),SORTED
JOINKEYS FILE=F2,FIELDS=(2,8,A),SORTED
JOIN UNPAIRED,F1,F2
OPTION COPY
Back to top
View user's profile Send private message

Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Mon Mar 22, 2010 5:17 pm    Post subject:
Reply with quote

Are there duplicates in the files?
It would be great if you could show sample input and expected output..

Also seeing your older posts,
Some time you have asked DFSORT solutions and some times SYNCSORT so again you need to confirm sort product you are using.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Mon Mar 22, 2010 5:19 pm    Post subject:
Reply with quote

This is a link to the DFSORT smart tricks documentation which has many examples of matching records.
Please click HERE to access it.

Because the solution for sort related questions may vary from product to product, please ensure that you state clearly which sort product you are using.

If you are not sure, then by running a simple sort step shown below, you will be able to find out for yourself.

If the messages start with ICE then your product is DFSORT. Please also post the output of the complete line which has a message code ICE201I, as this will enable our DFSORT experts to determine which release of DFSORT that you have installed. This may also affect the solution offered.

If the messages start with WER or SYT then the product is SYNCSORT and the topic will be moved into the JCL forum by one of the moderators. Please also post the information telling which version of SYNCSORT is installed, as this may also affect the solution offered.

Thank you for taking your time to ensure that the valuable time of others is not wasted by offering inappropriate solutions which are not relevant due to the sort product being used and/or the release that is installed in your site.

Code:
//SORTSTEP EXEC PGM=SORT
//SYSOUT   DD SYSOUT=*
//SORTIN   DD *
ABC
//SORTOUT  DD SYSOUT=*
//SYSIN    DD *
  SORT     FIELDS=COPY
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: Mon Mar 22, 2010 10:50 pm    Post subject:
Reply with quote

vsrao_2k,

DFSORT supports JOINKEYS. If you don't have the Nov, 2009 PTF for JOINKEYS, ask your System Programmer to install it (it's free). For more information, see:

http://ibmmainframes.com/viewtopic.php?t=45147

If you don't have that PTF and can't get your System Programmer to install it, run the following DFSORT job and post the //SYSOUT messages so I can see what level you're at:

Code:

//S1    EXEC  PGM=SORT               
//SYSOUT    DD  SYSOUT=*             
//SORTIN DD *                         
RECORD                               
//SORTOUT DD DUMMY                   
//SYSIN    DD    *                   
  OPTION COPY                         
/*                                   


Also, show an example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input files. If file1 can have duplicates within it, show that in your example. If file2 can have duplicates within it, show that in your example.
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 Converting decimal to numeric using I... Balaryan DFSORT/ICETOOL 4 Thu Feb 02, 2017 11:27 pm
No new posts Execessive parameter issue Sumeendar JCL & VSAM 5 Mon Dec 19, 2016 4:35 pm
No new posts DFHRESPONSE returns issue divated CICS 3 Wed Nov 02, 2016 6:32 pm
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
No new posts Can sending 5 MB data between cobol p... Kevin Vaz CICS 12 Tue Oct 18, 2016 4:50 pm


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