Re: It's SQL0312 reason code 6 again

BREAKING NEWS: my customer reports IBM wrote a PTF on 01/20 specifically
for this issue. The compiler is compiling and we're good for now.

Martijn, always *LVL2.

Turns out the customer applied PTF's and a TR to their V7R4 box yesterday
morning. They have forwarded the source and compile listings to IBM.

In the initial problem program (a complex order update program), I have
about 60 EXEC SQL's. An additional step I could take would be to comment
out the SQL touching these files (green-screen interactive, some
read/write, one read-only, using a cursor, using commitment control, using
a named activation group, using SET OPTION, accessing numerous service
programs, using LIMIT 1).

And then we have the %RANGE keyword that breaks RDi. This was a tough
weekend.

--reeve


On Mon, Jan 27, 2025 at 5:10 AM Daniel Gross <daniel@xxxxxxxx> wrote:

Hi Reeve,

in fact - the SQL0312 is often an error, that would also occur later in
the RPG compiler.

So commenting out some or all EXEC SQL statements, and trying to compile,
might give you more information.

HTH
Daniel



Von meinem iPad gesendet

Am 27.01.2025 um 13:58 schrieb Martijn van Breden <

m.vanbreden@xxxxxxxxxxxxxxxxxxxxxxxxxx>:

Hi Reeve

It has been suggested here before; try commenting out the failing exec

sql statement(s) to see if the RPG compiler itself has to say something
after you've passed the SQL precompiler stage. A typo in some spec may go
unnoticed by te preprocessor, but mess up the definitions anyway.

Assuming you have the RPGPPOPT control option set to *LVL2 of course.


Kind regards,



Martijn van Breden

lead software architect




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

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

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

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.