Archives of the TeradataForum

Message Posted: Fri, 07 Jan 2011 @ 09:25:21 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Make it multi-statement request...

     DELETE FROM ${PQA_GSC_DCM_DB}.table1
     ;DELETE FROM ${PQA_GSC_DCM_DB}.table2
     ;DELETE FROM ${PQA_GSC_DCM_DB}.table3
     ; DELETE FROM ${PQA_GSC_DCM_DB}.table4
     ; DELETE FROM ${PQA_GSC_DCM_DB}.table5;

If all the statements go through then only it will commit.. or it will roll bak...

Does that help?

	<Prev	Next>		<<First	<Prev	Next>	Last>>