SQL in Before Datadeploy

System

Hi,

I would like to run SQL before my datadeploy start.So i specifying like below my sql statement in datadeploy configuration


<deployment name= "DeployDCR">
<destinations>
<database use = "oracle9i" table = "no-table-needed">
<sql user-action="runquery" type="query">
select * from users where user_id =1
</sql>
</database>
</destinations>

Invocation:
iwdd.ipl cfg=deployment.cfg deployment=DeployDCR iwdd-op=do-sql user-op=runquery

It is working fine if i use select statement like above.

If i use delete from users where user_id=1 it is failing. Do i need to change any things if i use delete statement?


Thanx in advance