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
 
Using "ON" with multiple fields in SPLICE operator

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

New User


Joined: 14 Jul 2005
Posts: 2

PostPosted: Tue Apr 15, 2008 10:30 am    Post subject: Using "ON" with multiple fields in SPLICE operator
Reply with quote

Is is possible to put multiple fields in "ON" used in the Icetool splice operator?...I want to do a comparison between two files based on Multiple fields.
Back to top
View user's profile Send private message

Aaru

Senior Member


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

PostPosted: Tue Apr 15, 2008 4:46 pm    Post subject: Reply to: Using "ON" with multiple fields in SPLIC
Reply with quote

sagar,

Quote:
Is is possible to put multiple fields in "ON" used in the Icetool splice operator


Yes, you can ! Max of 10 ON fields can be used for matching.
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 Apr 15, 2008 9:07 pm    Post subject:
Reply with quote

Right. To quote from the SPLICE description in "z/OS DFSORT Application Programming Guide" at:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/6.13?DT=20060615185603

Quote:
From 1 to 10 ON fields can be used for the fields to match on. At least one ON(p,m,f) field must be specified; all such ON fields specified will be used to determine the matching records to be spliced together.


You can access all of the DFSORT books online from:

www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html
Back to top
View user's profile Send private message
sagardeshmukh81

New User


Joined: 14 Jul 2005
Posts: 2

PostPosted: Wed Apr 16, 2008 11:57 am    Post subject: Reply to: Using "ON" with multiple fields in SPLIC
Reply with quote

Got it....thankx a lot... icon_cool.gif

At first I was trying this....and got an error...

ON(1,11,CH,12,2,FI,14,10,CH,24,2,FI) -

Then got it corrected to...

ON(1,11,CH) ON(12,2,FI) ON(14,10,CH) ON(24,2,FI) -
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 Apr 16, 2008 9:50 pm    Post subject:
Reply with quote

You can't just guess at the syntax. You have to look it up in the manual.
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 Splice more than 50 occurances rajatbagga DFSORT/ICETOOL 1 Wed Oct 11, 2017 9:36 am
No new posts Addition of two records on 2 fields amar143 SYNCSORT 8 Tue Oct 03, 2017 11:14 am
No new posts ejck thru rexx to multiple jobs insid... Susanta All Other Mainframe Topics 5 Tue Sep 19, 2017 1:39 pm
No new posts PLI - printing from multiple programs Pedro PL/I & Assembler 8 Fri Sep 08, 2017 6:36 am

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