ETL and Data Integration tools - Modern ETL software for everyone

Hi all,

I'm having an issues when trying to run several SQL's in order to use the "Run as script" option.

Working on iSeries and connected through the database with ODBC connection ([IBM][iSeries Access ODBC Driver]).

I'm setting up the delimiter as ";" or using the "/" as proposed in the dropdown list.

Then when clicking the "Run as Script" option, I don't get any results.
Single SQL are working fine and populates the results

Would that be a problem of syntax?
A parameter in the ODBC Connection?
A Security setting on the AS/400?

Thanks in advance for your help.
Edoardo

so you have a script like this one

select * from table1
/
select * from table2
/
and you expect to see multiple results

It is not able to do that at the moment, but we can add support for it into future release.
This might take a while.

Mike

Hi Mike,

Thanks for your answer.
If it can be added in future release that would be great.

Only a question then, what the purpose of having that "Run as script" option if this is not feasible yet?!

Cheers!
Edoardo

Only a question then, what the purpose of having that "Run as script" option if this is not feasible yet?!

The purpose is very simple to run scripts

update table x
go
insert into table b
go
.....
etc

Many thanks for your answers Mike.
Didn't thought about inserts, deletes etc.. as mainly focusing on inquiries to the DB.

Thanks again.
Edoardo