Re: String Format Error

Jerry,

Chuck is right. (IIRC) For V5R1 the format is:

C/exec sql
C+ SELECT ....
C+ the rest of your statements...
C+ etc
C/end-exec

Free format for SQL did appear for V5R3 as a PTF (is was announced first, I
believe, for V5R4)

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Mon, Oct 24, 2011 at 1:14 PM, CRPence <CRPbottle@xxxxxxxxx> wrote:

On 24-Oct-2011 10:27 , Jerry C. Adams wrote:

Someone else, off-list, with a cruel and sadistic streak suggested that

it

was because I was still on 5.1; i.e., that the SQL pre-processor had an
issue with free-format code at that release.

http://archive.midrange.com/rpg400-l/200210/msg00270.html

* Subject: Re: MSG - The comment entry on a free-form calculation is not

valid

* From: "Bob Slaney" <rjslaney@xxxxxxxxxx>
* Date: Fri, 11 Oct 2002 06:41:29 -0400

The real problem is that the precompiler does not support free
form. As a result, it inserts the SQLDA in the wrong place and
causes all sorts of erroneous errors. I have played with adding
dummy D-specs and C-specs in order to work around this problem.
Sometimes, I have been successful, but many times not. For now,
what I am doing is avoiding embedded SQL with free form until the
precompiler is improved. Latest rumour is V5R3.

Bob
Bob Slaney/Atlanta/ibm@xxxxx (Lotus Notes)

HTH

Regards, Chuck
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.