topic How to execute a script SQL in Talend Studio

How to execute a script SQL

Anonymous — Sat, 16 Nov 2024 04:41:04 GMT

Hello, I m connection on a DB where there is many IP @.
I want to execute a SQL Script.
Any help please?

Re: How to execute a script SQL

fdenis — Fri, 13 Sep 2019 09:10:00 GMT

hi,
it's not clear…
did you want to contrôle the execution of the script?
is it a one shot?
what is your script?
does it return vualues?
on witch db type and version?......

Re: How to execute a script SQL

Anonymous — Fri, 13 Sep 2019 09:22:15 GMT

My script is an update in the data base.
First step in the job is to connect in an other data to extract IP adress
Then i have a script to updata an other data base, so i connect to a data with tdbconnect.

My script doesn't return values but i want to make sure that it's done on all servers (all @Ip)

I m working on Microsoft SQL Server

Re: How to execute a script SQL

fdenis — Fri, 13 Sep 2019 09:37:59 GMT

so, you may read your script file query by query (split line by .
then use tMSSqlRow or tdblRow to exécute each query getting execution result.