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 Data replication from multiple Db2 ta... kishpra DB2 5 Mon Mar 27, 2017 9:58 pm
No new posts Unable to catalog a gdg dataset resid... Shovan JCL & VSAM 7 Fri Mar 24, 2017 2:24 pm
No new posts To display values of multiple rows in... vinu78 DB2 2 Thu Mar 09, 2017 1:20 pm
No new posts DFSORT MUL FIELDS tspr52 DFSORT/ICETOOL 16 Fri Mar 03, 2017 11:53 pm
No new posts Sort two file having same field, one ... himanshu malik DFSORT/ICETOOL 7 Thu Feb 02, 2017 10:09 am


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