Execute as a Script

[Former Member]

Hi,

How can I execute the whole SQL script in one query template itself like

create table table1..

/

alter table table1..

/

create table table2..

/

....

I mean running more than one SQL statements in a single Query template.

Thanks,

Anil

[Former Member · Accepted solution]

Hi Anil,

Create a stored procedure in the database and execute it using a fixed query.

Hope that helps.

Regards,

Musarrat Husain

[Former Member · Accepted solution]

Hi Musarrat,

Thanks for the response.

How to execute a stored procedure using fixed query?

simply writing procedure name do not work......procedure1();

Regards,

Anil

[Former Member · Accepted solution]

Hi,

In Fixed Query you can write like this

EXECUTE STOREDPROC_NAME

'[Param.1]','[Param.2]',

Thanks,

Manisha

[Former Member · Accepted solution]

Hi Anil,

use FixedQueryWithOutput mode.

write EXECUTE <procedurename> or exec <procedurename> or call <procedurename> to execute the procedure from query template.

Regards,

Musarrat

[jcgood25]

Anil,

Use Command mode and not FixedQuery, since your query does not return a valid dataset. FixedQueryWithOutput, which was incorrectly mentioned in an earlier post, is only relevant for Oracle when the query returns a cursor holding the data set.

While a procedure will work for your needs, it is not exactly required. If the multi-line sql request is well formed (oracle requires BEGIN / END around the multi statements) then it should work, but if you use FixedQuery mode you will get a FatalError, even though the query was executed (this is because is does not return any dataset).

MII more or less just passes the query text through the JDBC driver to the DB on the other end for processing.

Regards,

Jeremy

[Former Member]

In Fixed Query you write

EXECUTE STOREDPROC_NAME

'[Param.1]'

,'[Param.2]'

In my last post instead of '[Param.1]' it is showing as https://

So i replied again the samething.

Thanks,

Manisha