× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. January 2015

Re: is there a way too batch SQL scripts

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

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.