|
View previous topic :: View next topic
|
| Author |
Message |
thoulath
New User
Joined: 15 Sep 2010
Posts: 18
Location: chennai
|
|
|
|
| Hi can we do splice operation without a common key? |
|
| Back to top |
|
 |
smijoss
Active User
Joined: 30 Aug 2007
Posts: 114
Location: pune
|
|
|
|
| u need to mention the ON parameter in splice .. check the document |
|
| Back to top |
|
|
Prasun De
New User
Joined: 17 Jan 2008
Posts: 28
Location: Kolkata, INDIA
|
|
|
|
Post your requirement clearly..
May be you can utilize some other option... Why you need Splice without common key? |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
sqlcode1
Active Member
Joined: 08 Apr 2010
Posts: 577
Location: USA
|
|
|
|
| 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 |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
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:
www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000094
for different ways to do this with DFSORT. |
|
| Back to top |
|
|
thoulath
New User
Joined: 15 Sep 2010
Posts: 18
Location: chennai
|
|
|
|
@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 |
|
|
thoulath
New User
Joined: 15 Sep 2010
Posts: 18
Location: chennai
|
|
|
|
| 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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 
I've locked this topic (it can be deleted later).
Let us know if there are any problems/questions.
d |
|
| Back to top |
|
|
|
|
