I have a target table say EMP table
I have to load 1000 records from a file into EMP table and say all the 1000 records coming from file have only the Dept no's 1,2,3
When my job runs,
my criteria is to delete all the existing records in the table with dept no 1,2,3
and load the fresh 1000 records into the target EMP table
thanks,
Suresh
deleting rows from a table and then inserting rows
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
deleting rows from a table and then inserting rows
Hi I have experience in parallel extender datastage I am ready to give/take help from other
hope we all help each other hand in hand
hope we all help each other hand in hand
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
Re: deleting rows from a table and then inserting rows
Could anyone elaborate on this
thanks
suresh
thanks
suresh
Hi I have experience in parallel extender datastage I am ready to give/take help from other
hope we all help each other hand in hand
hope we all help each other hand in hand
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
Re: deleting rows from a table and then inserting rows
Hi
I am happy to see the option "OPEN" as mentioned
but with write mode as upsert, I could not see that option
when I am trying to use write mode as "LOAD"
I am getting an error
Could you please suggest me a method only with Upsert write method
(where I will use only insert condition and put 1=2 in update condition)
and the "OPEN "command with write method as "UPSERT"
thanks
suresh
I am happy to see the option "OPEN" as mentioned
but with write mode as upsert, I could not see that option
when I am trying to use write mode as "LOAD"
I am getting an error
Could you please suggest me a method only with Upsert write method
(where I will use only insert condition and put 1=2 in update condition)
and the "OPEN "command with write method as "UPSERT"
thanks
suresh
Hi I have experience in parallel extender datastage I am ready to give/take help from other
hope we all help each other hand in hand
hope we all help each other hand in hand
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: