Insert after target write

snassimr · Post by **snassimr** » Thu May 26, 2005 6:48 am

Hi !

If anybody can help me.

I have ODBC stage for writing of target table
After the rows written I want to insert one more row with specific values.

How can I to do it in one job ?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu May 26, 2005 7:14 am

Simplest will be to perform an 'after job' sql to insert row. If you want to keep everything in DataStage, you can include that as a separate link in your job.

As you said that it must be 'after' the rows are inserted, I believe it will have to do something with row count, reject info etc.

snassimr · Post by **snassimr** » Thu May 26, 2005 7:17 am

Ok . I need one more link to odbc stage of target table . But where I can to write my insert statements ???

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu May 26, 2005 7:24 am

In the connected ODBC stage.....obviously.

snassimr · Post by **snassimr** » Thu May 26, 2005 7:38 am

I can do it only choosin UPdate action is "User defined SQL" in inputs tab ?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu May 26, 2005 7:58 am

What exact action you wish to perform?

snassimr · Post by **snassimr** » Thu May 26, 2005 8:21 am

I have ODBC stage that writes target table
with update option "clear table and insert rows" and i want to use this option

I want immideatly after / or before run insert SQL that insert one my row with specific values to this target table

If I choose user - defined SQL in UPdate option I need to
write all SQL handly .

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu May 26, 2005 11:44 am

Best is to have this as a stand-alone job.

ranga1970 · Post by **ranga1970** » Thu May 26, 2005 12:03 pm

after job subroutene can be of help