DD 6.0.x iwodcmd support of iwdd.ipl syntax

Does anyone know whether the "iwdd-op=do-sql" and "user-op=operation" options that were part of iwdd.ipl in DD 5.6 and prior are still recognized and supported using iwodcmd start with DD 6.0.2 ?

If they are not, then how would you write and then invoke a DD config in 6.0.2 to run arbitrary SQL commands?

Our current DD 5.6 config goes something like this:

<data-deploy-configuration>
<substitution name="GlobalSubstitution"> ... </substitution>
<filter name="MetadataGenericFilter">... </filter>
<client>
<deployment name="ea-to-db">
<source>
<teamsite-extended-attributes
options = "wide"
area = "$areapath^">
<path name="$dirpath^" visit-directory="deep"/>
</teamsite-extended-attributes>
</source>
<destinations>
<database db = "$db^"
...
table = "MY_LOAD_TABLE"
update-type = "standalone"
...
>
<sql user-action="drop" type="update">
DROP TABLE MY_LOAD_TABLE
</sql>
<dbschema>
...
</dbschema>
</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>

And we invoke the SQL to drop the table using:
iwdd.ipl cfg=mydd.cfg deployment=ea-to-db "db=mydb Smiley Tongue

ort:myuser" "areapath=/default/main/mybranch/STAGING" "dirpath=mydir" iwdd-op=do-sql user-op=drop

Find more posts tagged with

Comments

Adam Stoller

ort:myuser" "areapath=/default/main/mybranch/STAGING" "dirpath=mydir" iwdd-op=do-sql user-op=drop

I believe that all options are still supported, though I could be wrong. Have you tried this with DD 6.0.2 yet? If so - how are you invoking it (you showed the 5.x command, not the 6.x command)? Did you read the section of the manual that deals with converting from 5.x to 6.0.[12]?

--fish
Senior Consultant, Quotient Inc.
http://www.quotient-inc.com

Freedom

it does support it. Here is the sytax:

$iwodhome/bin/iwodcmd start "DD_Configure_file" -k iwdd=deployment -k value=name

Note: You have to copy all your configure files from $iwddhome/conf to $iwodhome/conf, and rename it with xml suffix instead of cfg.

kgilmore

Thanks. I did finally find an example in Chapter 6 (Advanced Features) p. 161 of the DD 6.0.2 admin guide, and it used these options. I tried it with 6.0.2 and it worked fine.
I invoked it in 6.0.2 as follows:

iwodcmd start mydd -k iwdd=ea-to-db -k "db=mydb Smiley Tongue

ort:myuser" -k "areapath=/default/main/mybranch/STAGING" -k "dirpath=mydir" -k iwdd-op=do-sql -k user-op=drop

Also I found that if you add "-k logfile=mylogfile.log" to the param list, then it will extract the DataDeploy-specific section of the log to the file you specify, while all the setup and teardown portions of the process continue to be appended to the standard log files.