× 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.



Jon,



Your right! It does work! My mistake!



I was debugging with my co-worker, and the sql statement was not working…



I shift it over to before column-80. Then I discovered that I missed the open on the declare cursor….



So, thankfully, no problem going past column-80 with SQL Statements! My mistake!



-Ken Killian-



________________________________
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of Jon Paris <jon.paris@xxxxxxxxxxxxxx>
Sent: Sunday, August 11, 2019 6:08:53 PM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries <wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WDSCI-L] RDI still stuck in 80 column punch-card mode with SQL. Maybe compiler limitation?

"PS. I am just really trying to met deadlines. Sorry, for coming across so negative. My bad."

It's OK - we are used to it.

I suspect that if there is a limitation it is in the pre-compiler - but I thought that had fixed that.



On Aug 11, 2019, at 5:58 PM, Ken Killian <kkillian@xxxxxxxxxxxx> wrote:

Side note, we are fairly current on IBM I 7.3, with recent TR, I am pretty sure….



Is there a simple way to check our Technology refresh level? Oh yeah, I am using RDI 9.6.0.6, the latest greatest. But, I assume this is really a compiler issue, not completely sure.



Just need to get my work done. Might as well stick to IBM’s beloved punch-card limitation of maximum of 80-columns. My fault for going past punch-card-column 80. My bad.



-Ken Killian-



PS. I am just really trying to met deadlines. Sorry, for coming across so negative. My bad.







________________________________
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of Ken Killian <kkillian@xxxxxxxxxxxx>
Sent: Sunday, August 11, 2019 5:28:09 PM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries <wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: [WDSCI-L] RDI still stuck in 80 column punch-card mode with SQL. Maybe compiler limitation?

Hi,

My SQLRPGLE code failed on SQL Statement going past punch-card column 80. Which I guess/Assume is a problem with the compiler. But, RDI 9.6.0.6 does not tell me that. Neither does the compiler.

Put back in the 80-columns like the 1960's punch card machine, and then it works...

So much for **free being "Truly" Free.

No wonder our box is called the Univac-Punch-Card-400. perception is reality... <sad face>


--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/wdsci-l.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/wdsci-l.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/wdsci-l.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

As an Amazon Associate we earn from qualifying purchases.

This thread ...

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.