Re: is there a way too batch SQL scripts

To add to the thread - not directly replying to Rob - I found a Java-based SQL client that claims to be able to run SQL scripts in either interactive or batch mode.

It is called SQL Workbench/J - web page is http://www.sql-workbench.net/

I've not used it, so it's up to y'all to see if it works for you.

Google is our friend!!

Now to add something to Rob's post - a *QMQRY object can have only 1 SQL statement, whereas RUNSQLSTM can use a script with multiple SQL statements. SELECT is NOT one of the statements allowed with RUNSQLSTM or the more recent RUNSQL - sigh!!

Vern

On 1/7/2015 10:03 AM, rob@xxxxxxxxx wrote:

EDTF on 7.2, when used on source physical files, only supports those with
a row size of 4k or less.

CRTQMQRY: QWM1580-IMPORT source record length exceeds 79 characters.

RUNSQLSTM will fail on a source statement with 'select' in position 1 and
'* from myschema/mytable' in position 3900 with
MSG ID SEV RECORD TEXT
SQL0104 30 2 Position 1 Token <END-OF-STATEMENT> was not valid.
Valid
tokens: ( + * - ? : DAY INF NAN RID ROW RRN.

The help for the command does not list the source statement maximum.

If I bunch it all together I get the usual error about a select statement
being invalid in a RUNSQLSTM command.
SQL0084 30 1 Position 1 SQL statement not allowed.
I only said this because some people will focus on my using a select
statement above. Of course, if such stuff blinds them they'll probably
have already stopped reading this.

Rob Berendt