nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

stored procedure

HAL

Hi all,
Using dd5.6,
Urgent
has someone a clear example of a deployment calling a stored procedure and passing parameters

thanks

Find more posts tagged with

Comments

Migrateduser

iwdd.ipl cfg=execsp.cfg deployment=execproc iwdd-op=do-sql user-op=exec_procedure

<deployment name="execproc2">
<destinations>
<database
use = "db281"
table = "no-table-needed">
<sql user-action="exec_procedure" type="exec-proc">
update_bonus('000010')
</sql>
</database>
</destinations>
</deployment>

Report.zip

HAL

Well,
now let's imagine i've got such deployment :
<deployment name="multi" options="transactional">
<exec-deployment use="B1" />
<exec-deployment use="B2" />
<exec-deployment use="B3" />
<exec-deployment use="B4" />
</deployment>
let's imagine i wanna have many store procedure calls
one for B and another for B4

how to call the "multi" deployment ( the generic one to get B3 and B4 executing the store procedures

is it something like iwdd.ipl cfg=execsp.cfg deployment=multi iwdd-op=do-sql user-op=exec_procedureB3,exec_procedureB4 ...?

thanks

AramexReport55.ssd.zip

14143.pdf

Migrateduser

Chained stored procedure invocations are not supported curently. Please file a request with TechSupport.

HAL

So i can't have a transactional deployment is it ..?
i'm obliged to call B3, B4 deployments with respective user-op parameters..the problem is that i'd like them to be part of a transaction with other deployments to other tables is it really impossible ...??
any trick ..?

thanks