|
| Re: RUNSQLSTM Limit help |
 |
Wed, 28 Nov 2007 19:45:35 EST |
<div class="jive-quote"><div
class="jive-quote">Knoel wrote:<br />
<div class="jive-quote">Is there any qay to get around the
RUNSQLSTM limit of 80 character width on the source
file?</div></div></div>
<br />
<div class="jive-quote">CRPence wrote:<br />
<div class="jive-quote">No, not with that command function
itself.<br />
Meaning... The limitation must be circumvented either using another tool, or by
preparing a front-end to that tool which satisfies the 80-byte source record
requirement. For example a .sql script stored in the root file system could have
a tool in the form of an alternate command like:<br />
RUNSQLIFS STFM('/tmp/myscript.sql') RUNSQLPARMS('COMMIT(*NONE)
NAMING(*SQL)')<br />
The command processing program could effect the open of the 'myscript.sql' and
parse the text lines into 80-byte strings inserted into a source file member in
QTEMP, and then issue in CLP syntax:<br />
|
| Post Reply
|
|
|
|
|
|
|
|
|
|