You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Create a duplicate rowset for a new key set based on a existing key set in a 3 level rowset

1 reply [Last post]
Guest's picture
Guest

Hi,

I want to create a duplicate rowset for a new key set based on a existing key set in a 3 level rowset..

Eg;
Level0 Record:
Key1: A1
Field1:Abc

Level1 Record:
Key1:A1
Key2:A2
Field2:Abcd

Level2 Record:
Key1:A1
Key2:A2
Key3:A3
Field3:Abcde

Level3 Record:
Key1:A1
Key2:A2
Key3:A3
Key4:A4
Field3:Abcdef

So i want to create duplicate rowset for another level0 key B1 such that the rest of the fieldvalues in the level rowset is the same as the existing one. Like

Level0 Record:
Key1: B1
Field1:Abc

Level1 Record:
Key1:B1
Key2:A2
Field2:Abcd

Level2 Record:
Key1:B1
Key2:A2
Key3:A3
Field3:Abcde

Level3 Record:
Key1:B1
Key2:A2
Key3:A3
Key4:A4
Field3:Abcdef

Its just like a copy feauture for a new keyset.

Im getting few sql errors with my peoplecode. Can anyone share ur thoughts??

ruelmcleur's picture
User offline. Last seen 9 years 33 weeks ago. Offline
Joined: 05/27/2011
Posts: 1
Re: Create a duplicate rowset for a new key set based on a ...

anyone can share there application in sql