Re: is there a way too batch SQL scripts

I understand that you want to run these scripts on your PC. So I think
you're looking for something like the commands IBM supplies for batch file
transfer but instead supports your PC based SQL scripts.
Most others are suggesting running commands on the IBM i to run SQL. They
might not understand what you are asking. But to put them into a positive
light, running the SQL on the IBM i might perform better by doing all the
summarizing on the big iron and just passing the results back to the PC.
Failing that, and a continuation on attempting to run SQL scripts directly
on your PC I know there is a way. We actually did this from DOS before I
discovered the old freebie RUNSQL (which was supplanted by IBM coming out
with their own a decade or so later). Now if I could only remember how...
Got a lot of work to catch up...
Maybe the ODBC connectivity stuff?
Maybe putting the SQL into excel?
Maybe just running the file transfers and then accessing the downloaded
data?


Rob Berendt