DSXchange

We are trying to comment out few SQL statements from the After SQL or Before SQL tab in Oracle OCI stages in Datastage Server version 7.5.

We have tried a no. of options like -

/* Delete from table_name*/
-- Delete from table_name
#Delete from table_name#

How ever none of the above 3 options worked.
We would not want to simply wipe out the SQL statement from the After SQL or Before SQL, however, would like to keep it but not have it executed. Can this be achieved? If yes, please let us know how.

Thanks!
Ratul.

What do you mean by "did not work"?

It may be that there has to be some statement there. I use an additional WHERE clause, such as DELETE FROM TABLE WHERE 1=0. Oracle is quite happy to delete the 0 rows that match my condition.

Or just move them elsewhere. I move old or obsoleted statements of that type into the Description box on a General tab, with comments as to where it came from and when/why it was removed.