Listing / Finding BEFORE SQL Statements

[MT]

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

[ArndW]

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.