Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does anyone know if it is possible to execute multiple SQL statements in a tAS400Row Component similar to tMySQLRow using "allowMultiQueries=true"
This doesn't appear to work for tAS400 components & throws the usual end of statement error
.
We are using Talend version 6.4.1
Thanks in advance
Thanks for the reply.
I don't actually need the statements to run in parallel, they execute sequentially, but the job I'm trying to automate would have 450 statements to execute in sequence. Trying to build that one row component at a time would be painful so I was hoping to be able to just paste my whole script into a single component.
If that option isn't available, then I suppose I will have to do it the long way!
I have an update on this, an easier solution is to wrap the statements between BEGIN and END statements
eg:
BEGIN
DROP TABLE schema.table1;
CREATE TABLE schema.table1 .....(table stuff here);
GRANT SELECT on schema.table1 to USER;
END
This greatly simplifies maintenance of code & processes automated using talend.
Hello ,
I'm facing similar problem could we have an update on this ?