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
 

 

Can we do splice operation without a common key?

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
thoulath

New User


Joined: 15 Sep 2010
Posts: 18
Location: chennai

PostPosted: Wed Sep 15, 2010 3:00 pm    Post subject:
Reply with quote

Hi can we do splice operation without a common key?
Back to top
View user's profile Send private message

smijoss

Active User


Joined: 30 Aug 2007
Posts: 114
Location: pune

PostPosted: Wed Sep 15, 2010 4:52 pm    Post subject:
Reply with quote

u need to mention the ON parameter in splice .. check the document
Back to top
View user's profile Send private message
Prasun De

New User


Joined: 17 Jan 2008
Posts: 28
Location: Kolkata, INDIA

PostPosted: Wed Sep 15, 2010 5:41 pm    Post subject:
Reply with quote

Post your requirement clearly..
May be you can utilize some other option... Why you need Splice without common key?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Sep 15, 2010 7:53 pm    Post subject: Reply to: Can we do splice operation without a common key?
Reply with quote

Hello,

Is the same question as your other topic named Merge two records without a common field?

Posting duplicates is the fastest way to get warned or banned. . .

If you explain why you believed it acceptable to re-post your question, do let us know otherwise this needs to be deleted.

d
Back to top
View user's profile Send private message
sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 578
Location: USA

PostPosted: Wed Sep 15, 2010 8:15 pm    Post subject:
Reply with quote

thoulath wrote:
Hi can we do splice operation without a common key?


To answer your question, Yes you can do that but you would have to generate common key based on your requirement. An example of the requirement would to match 1st record of File1 with 1 st record of File2. You don't have a common key for the files. In this case, you would add SEQNUM to both the files and then perform SPLICE operation with SEQNUM field defined as ON fields.

If you need something specific, please provide some example of the input data and your expected output.

Thanks,
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 Sep 15, 2010 10:52 pm    Post subject:
Reply with quote

SPLICE requires a key for the comparison so you can't do a SPLICE without a key. However, you can add a key to each file to do the SPLICE on and then remove it.

See the "Join fields from two files record-by-record" Smart DFSORT Trick at:

http://www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000094

for different ways to do this with DFSORT.
Back to top
View user's profile Send private message
thoulath

New User


Joined: 15 Sep 2010
Posts: 18
Location: chennai

PostPosted: Thu Sep 16, 2010 2:23 pm    Post subject:
Reply with quote

@dick scherrer
I tried to post the question in a different topic which was related to SPLICING. By mistake it has been posted as a separate topic. this was done mistakenly. I dont know how to delete this topic now. Pls help.
Back to top
View user's profile Send private message
thoulath

New User


Joined: 15 Sep 2010
Posts: 18
Location: chennai

PostPosted: Thu Sep 16, 2010 2:25 pm    Post subject:
Reply with quote

Those who are ready to reply to my questions pls do reply for the queries under the topic "Merge two records without a common field"
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Sep 16, 2010 7:20 pm    Post subject: Reply to: Can we do splice operation without a common key?
Reply with quote

Hello,

Quote:
By mistake it has been posted as a separate topic. this was done mistakenly. I dont know how to delete this topic now. Pls help.
Not to worry icon_smile.gif

I've locked this topic (it can be deleted later).

Let us know if there are any problems/questions.

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    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 Joinkeys operation when key1 and key2... Susanta DFSORT/ICETOOL 5 Wed Nov 02, 2016 5:35 pm
No new posts Joinkeys operation betwen VB and FB file Susanta SYNCSORT 4 Sun Sep 25, 2016 9:49 pm
No new posts Matching records using splice for COM... hiravibk DFSORT/ICETOOL 4 Sun Sep 27, 2015 12:05 pm
No new posts CPU Consumption in Common Area Virendra Shambharkar COBOL Programming 8 Tue Sep 08, 2015 12:23 pm
No new posts how to eliminate records from operati... PUMA DFSORT/ICETOOL 5 Tue Dec 23, 2014 4:42 pm


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