Re: Parameters with DSQL-tasks [XPA3.2]
toggle quoted messageShow quoted text
That's right , strange behavior ...
but both solutions works fine :
1. moving DSQL to subtask
2.using local variables for output
anybody know the limit of charaters in DSQL statement (in magic task) ?
Ariel Kotler - Magic Line
On Thursday, December 6, 2018, 7:59:19 PM GMT+2, Avgerinos <mento@...> wrote:
DirectSQL input parameters work ok for me (at least in in XPA3.1x)
But regarding DirectSQL output-parameters, I found they will not work if
they are also declared as task parameters.
So I use local variables instead and update the task-parameters on task
On 5/12/2018 4:05 μμ, Florian Groothuis wrote:
> Hi all,
> I have a batch task with 3 parameters and the main source is a
> DirectSQL command. One of the parameters is the input parameter for
> the DSQL, the other two are the output parameters of the DSQL
> Surprisingly, when I call the task, the parameters are not filled with
> the values I pass. If I move the DSQL-task to a subtask, the task
> works fine.
> Is there different behaviour of parameters on a DSQL-task I don't know of?