DSXchange

Did you check that ? :

http://www-01.ibm.com/support/docview.w ... wg21666812

Did you try to delete the rows using a request like this? DELETE FROM #Parameter A# WHERE #Parameter# IN ( SELECT #Parameter# FROM #Parameter A#,#Parameter B# WHERE A.column=B.column ) Or if that's not too restrictive: DELETE A FROM #Parameter A# A,#Parameter B# B WHERE A.column=B.column Using a Ter...

If you have to extract the data you want to delete to a DataSet, you can simply use the database connector as output: on the usage menu, set the "Write mode" value to "Delete"
If the column you store in the DataSet is defined as a key, the data will be deleted.

A DB2 Connector can only have one "Stream" output, so, you can only create one DataSet at a time.

The easiest way to extract multiple tables to multiple DataSets is to create a generic multiple instance job with the name of the table and the name of the DataSet as parameters.

I use to have the same issue, i had that input : FIELD --------------- AAA;BBB;CCC;DDD AAA;BBB;CCC;DDD And i had to get that output : FIELD --------------- AAA BBB CCC DDD AAA BBB CCC DDD I do it by using a loop on a transformer (i think it's aviable since DataStage 8.5) : I create a Stage Variable ...