topic Re: Multiple statements in a single tAS400Row Component in Talend Studio

Multiple statements in a single tAS400Row Component

Anonymous — Sat, 16 Nov 2024 07:44:21 GMT

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

Re: Multiple statements in a single tAS400Row Component

fdenis — Fri, 31 Aug 2018 11:50:55 GMT

allowMultiQueries=true, depend on the JDBC Driver option.
I think that there is no similar option in AS400.
but if you rely need it, you can configure parale run on Talend Job.

Re: Multiple statements in a single tAS400Row Component

Anonymous — Fri, 31 Aug 2018 12:18:37 GMT

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!

Re: Multiple statements in a single tAS400Row Component

fdenis — Fri, 31 Aug 2018 12:43:30 GMT

you can read your script file and run query one by one.
Regards,

Re: Multiple statements in a single tAS400Row Component

Anonymous — Fri, 31 Aug 2018 15:28:09 GMT

At the risk of sounding completely dense - which components would you use to execute the commands from the file using tAS400 components?

Re: Multiple statements in a single tAS400Row Component

fdenis — Fri, 31 Aug 2018 15:38:01 GMT

it depend of the queries and the file structure.
Read queries: tFileInputRaw or Delimited (depend on file format)
Execute queries : tAS400Row tAS400Input (depend on queries)
It's possible to be compatible with all type of query (analyse query before execute)
It's possible to add comment into Script file to choose the destination of data...…
Regards

Re: Multiple statements in a single tAS400Row Component

Anonymous — Mon, 19 Nov 2018 08:56:46 GMT

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.

Re: Multiple statements in a single tAS400Row Component

kakooo16 — Mon, 03 May 2021 14:05:26 GMT

Hello ,

I'm facing similar problem could we have an update on this ?