Re: Converting SQL scripts from iNavigator to Source files

On Mar 14, 2015, at 12:38 PM, Arco Simonse <arco400@xxxxxxxxx> wrote:

Hi Darryl,

Your SQL statements can be as wide as the record length (minus the space
for the change date area) that is specified on your source file, normally
112 I think?
On the RUNSQLSTM you can use the MARGINS(200) parameter to set the width to
200, but then your sourcefile must also have a bigger width, else it will
have no effect.

I find myself using two other options when I have wide statements.

a) Copy the whole statement into Notepad++ where I use a very nice plugin
called "Poor Man's T-Sql Formatter" (there is also an online service:
http://poorsql.com ) and reformat it to specific size so that it fits in
the traditional sourcemember.

b) Save the wide source as it is on the IFS and use the SCRSTMF parameter
(I believe available since V6.1) on the RUNSQLSTM command.
RUNSQLSTM SRCSTMF('/mysrc/sqlsrc/modsrc/m00000116i.sql')
I don't know what the width limit for the IFS is, but I do have
statements of 3000 characters on one source line (only CRLF at end of the
complete statement) and they run without problems.

Hope that helps.

Best regards,
Arco Simonse

...

2015-03-14 14:59 GMT+01:00 Darryl Freinkel <dfreinkel@xxxxxxxxxxxxxxxxx>:

Does anyone know what the maximum width a source for SQL can be?



I need to isolate which statements are causing slow run times and which
part
of a script is failing. Running the script in iNavigator does not provide
enough feedback even when including debug facilities.



Using the RUNSQLSTMT command provides a nice audit trail which I want to
use.



I ask the question because my scripts go out to 200 characters wide and I
do
not want to have to reformat a ton of code. If I could just paste the code
into RDI and then run it, we would all win.



Darryl Freinkel

Assignment 400 Group, Inc.

Tel: 770.321.8562 ext 111 | Fax 770.321.8562 | 2247 La Salle Dr, Marietta
GA, 30062, USA | PO Box 72556, Marietta, GA 30007-2556



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.