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

Michael

If you have a look at the DTD

<!ELEMENT sql (#PCDATA)>
<!ATTLIST sql
user-action CDATA #REQUIRED
type (exec-proc | query | update) #REQUIRED
action CDATA #>

Then it would appear that for a delete statement you would want a type="update", not type="query".

hth

Cheers
Michael