Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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?

Labels (3)
1 Solution

Accepted Solutions
fdenis
Master
Master

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

View solution in original post

3 Replies
fdenis
Master
Master

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?......
Anonymous
Not applicable
Author

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

fdenis
Master
Master

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