Hi,
I am doing Upsert: Update then Insert to DB2 Table using ODBC Enterprise Stage. I am using Userdefined query.
Update working fine but Insert is not working. In log No Error Massage,No warning.
Only insert AND only update works fine with same query
If any one come across this type of issue then please advise to resolve this.
Thanks.
Update then Insert : Insert not Working in ODBC Enterpeise
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
If Insert and update are working fine then why not work with them instead of upsert. I guess both will give you same result. Something like this :
Code: Select all
insert
--------->
--> Transformer stage ODBC Enterprise stage
--------->
update
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
Thomas Alva Edison(1847-1931)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: