|
All:
For those of you using free-format SQL embedded in RPGLE, have you tried
putting mod-marks in columns 1-5 on the SQL lines? I'm getting a
pre-compiler error on the following code:
V102S exec sql
V102S insert
V102S into cltdebitpf
V102S values (
V102S :alphaclt,
V102S :name,
V102S :alphaaba,
V102S :acctnbr,
V102S :trancode,
V102S :alphaamt
V102S );
Here is the error message:
MSG ID SEV RECORD TEXT
SQL0104 30 1004 Position 17 Token V102S was not valid. Valid tokens: (
END GET SET CALL DROP FREE HOLD LOCK OPEN WITH ALTER
BEGIN.
Removing the mod-marks from all but the first line eliminates the problem,
as the following compiles cleanly:
V102S exec sql
insert
into cltdebitpf
values (
:alphaclt,
:name,
:alphaaba,
:acctnbr,
:trancode,
:alphaamt
);
SEU and WDSc are consistent with the pre-compiler...all indicate that the
first example is an error. Does free-form SQL in RPGLE use columns 1-5? No
other free-form statements do. Is this documented somewhere?
I am on V5R4 and should be pretty current with PTFs. Anyone have any
information on this?
Thanks,
--Bruce Guetzkow
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.