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.
How to comment out After SQLs or Before SQLs in Datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.