How to execute a script SQL

Highlighted
Five Stars

How to execute a script SQL

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


Accepted Solutions
Twelve Stars

Re: How to execute a script SQL

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

Francois Denis

Tag as "solved" for others! Kudos to thanks!


All Replies
Twelve Stars

Re: How to execute a script SQL

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?......

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Five Stars

Re: How to execute a script SQL

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

Twelve Stars

Re: How to execute a script SQL

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

Francois Denis

Tag as "solved" for others! Kudos to thanks!

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Talend Studio Improvements for API Services

Take a look at the Talend Studio improvements for API Services

Watch Now

Data Integration Success Stories

Take a look at some Data Integration success stories

Read