Re: Statement gives error in RUNSQLSTM

[Jeff Young <cooljeff913@xxxxxxxxx>]

Birgitta sent a replay regarding this before.
In case you missed it:
<snip>
Beginning with Release 6.1 (or 7.1) RUNSQLSTM was enhanced by an option
MARGINS that allows to use SQL script past column 80.
(Default for MARGINS is 80, but can be enhanced up to 32754)
</snip>

 
Jeff Young 
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2 
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions 
Designer V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical 
Solutions Implementer V5R3 

  
 






________________________________
From: Bryce Martin <BMartin@xxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Sent: Thu, October 7, 2010 2:05:57 PM
Subject: Re: Statement gives error in RUNSQLSTM

As I recall DCR style requests can be made from the COMMON website?  I've 
either issued or signed onto requests to remove column limits before.


Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777



"Mark S. Waterbury" <mark.s.waterbury@xxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
10/07/2010 10:00 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Subject
Re: Statement gives error in RUNSQLSTM






  Hi, Bryce:

If you don't like it, why don't you open a DCR with IBM to suggest that 
the RUNSQLSTM command should check the record length of the source 
physical file, and act accordingly?  Or, provide an optional SCANCOLS(1 
80) parameter, so you can override this as needed or desired?

Many people like to complain about the midrange platform ("The AS/400 
cannot do xxxxx"), yet they never even OPEN A DCR for those issues...

Complaining on these e-mail lists is not the same as opening a DCR. 
Some folks at IBM monitor some of these lists, but this is not the 
proper forum to suggest enhancements or report problems to IBM.  IBM 
already has a formal process in place for that purpose -- PMRs (for 
problems) and DCRs (for design change requests, aka. "enhancements".) 
And, you can now do it all from the web (for several years now.)

Mark S. Waterbury

> On 10/7/2010 9:35 AM, Bryce Martin wrote:
> Grrrrreeeeaaaaat!  haha.  stupid column limits.  That's my biggest
> frustration with this platform, ahering to the old punch card style 
column
> crap.
>
> Thanks
> Bryce Martin