Executing stored procedure along with DAta Deploy

System

Hi,

I am trying to execute a stored procedure along with the normal data deploy but none of the deployment is working, but the status is shown as completed.

I am attaching the DD config file along with the post.

There are in all 4 deployments defined in the config file.
Two of them (basearea and content) are normal DD definitions and the third one (stored) is for executing stored procedure.

The fourth one calls the other three deployments and execute them.
as shown below.

deployment name="multi"
exec-deployment use="basearea"/
exec-deployment use="content"/
exec-deployment use="stored"/
/deployment

Now when i execute the following commands
-----------------------------------------------------------------------
1) iwodcmd start product_dddeploy10 -k iwdd=multi -k [some other parameters that are required are passed]

In this case if my "multi" definition is as follows
=======================================
deployment name="multi"
exec-deployment use="basearea"/
exec-deployment use="content"/
/deployment
=======================================

Then above scenario works perfectly fine.
-----------------------------------------------------------------------

2) iwodcmd start product_dddeploy10 -k iwdd=stored -k iwdd-op=do-sql -k user-op=execute_my_procedure -k [some other parameters that are required are passed]

In the above command i directly call the 'stored' deployment definition and the stored procedure executes fine.

-----------------------------------------------------------------------

In third case when i combine the above the deployment is shown as success but there is not data transferred.

3) iwodcmd start product_dddeploy10 -k iwdd=multi -k iwdd-op=do-sql -k user-op=execute_my_procedure -k [some other parameters that are required are passed]


and use
=======================================
deployment name="multi"
exec-deployment use="basearea"/
exec-deployment use="content"/
exec-deployment use="stored"/
/deployment
=======================================
In this case no data is deployed but the deployment status is shown as success

-----------------------------------------------------------------------


I know the post is too big but... couldn't have described the issue i am facing.

Can somebody help me on this???

thanks
-Dixit

TS 6.5
Windows
Opendeploy 6.0

Migrateduser

I'm not sure that you can run stored procs with this method. I could be wrong but I prefer using "do-sql" when I need to do this because I tend to be somewhat untrustworthy of DataDeploy.

do-sql is in the documentation and it allows you to write a chunk of arbtirary SQL instead of doing the traditional field mapping. You can get as crazy as you want to with it, too... if your SQL chunk works in your query tool, it will work in a do-sql block, as well.