DSXchange

Hi,

I want to trace a bug in a projekt (multiple Jobs) and therefore I have to find a certain drop / delete table statement in BEFORE SQL section of DB2 stage.

The problem must have come in by copying a stage with a BEFORE SQL statement from one job to an other - so the BEFORE SQL is still deleting my result table

Has anyone a UNIVERSE query for that or any other idea how to find that problem and to identify the job with the wrong BEFORE SQL statement?

Thanks in advance
Michael

Michael, the easiest method is to do a full DataStage export and then simply search the .dsx for the SQL string, that will quickly let you identify the job(s) where it is used.