Datadeploy sql

olivierb

Hi

I would like to use sql command inside my datadeploy config file, I looked inside tthe doc but the example are not very clear. Any help would be welcome, what I would like to do is : using datadeploy deleting some rows inside the database

I have tried the tag <db-producer-query> but without success

Thanks for the help

Olivier

Migrateduser

You can use the iwdd-op option as shown below:

config:
<deployment name= "select">
<destinations>
<database
use = "oracle9i"
table = "no-table-needed">
<sql user-action="runquery" type="query">
select * from bookexec
</sql>
</database>
</destinations>

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