Duplicate record insert with other value
Moderators: chulett, rschirm, roy
Duplicate record insert with other value
I have a requirement like
If id=1 and cd=10 then 'a'
If id=1 and cd=10 then 'b'
If id=1 and cd=10 then 'c'
if the same record comes again from source then need to chage the value
target is oracle table.
May i know the logic behind this to do
If id=1 and cd=10 then 'a'
If id=1 and cd=10 then 'b'
If id=1 and cd=10 then 'c'
if the same record comes again from source then need to chage the value
target is oracle table.
May i know the logic behind this to do
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
All records are coming from source no need to generate a column in the middle. the way source records are coming need to insert in target
All three recors are coming from the source with the same value
First record will insert directly with one value
Second record will be duplicate so it is not going to insert directly then need to inset with other value for same target fields.
Please let me know if i am not able to explain properly
All three recors are coming from the source with the same value
First record will insert directly with one value
Second record will be duplicate so it is not going to insert directly then need to inset with other value for same target fields.
Please let me know if i am not able to explain properly
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can "increment" a single character.
Code: Select all
Char(Seq(prevcharacter)+1)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.