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
 

 

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 SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 5 Sat Jan 21, 2017 4:02 am
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am
No new posts Amount field is getting corrupted whe... thesumitk SYNCSORT 5 Tue Oct 18, 2016 8:20 pm
No new posts hot to get details when "EXEC CI... Andi1982 CICS 11 Tue Sep 20, 2016 5:01 pm


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