Hi Scott,
I remember there was a situation where the SQL Pre-compiler information was inserted at the wrong place (... but I don't know which PTF fixed it).
The situation where it happened occurred, if there were no global D or F specs or only D or F specs hidden within copy members.
I circumvented the problem at that time (and continued to do it with every embedded SQL source), I just defined a dummy variable in the global D specs.
May it will also help with your current problem.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them and keeping them!"
„Train people well enough so they can leave, treat them well enough so they don't want to.“ (Richard Branson)
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Scott Klement
Sent: Dienstag, 24. März 2020 20:47
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: Embedded SQL Precompiler
Hi All,
Does anyone know the right/best way to get the latest PTFs for the embedded SQL precompiler for RPG?
I'm already up-to-date on the latest group and cume PTFs for IBM i 7.4. (Including the ST1 group)
The problem I'm having is that the precompiler is inserting code in the wrong place in the program. It'll insert definitions, for example, after the main procedure and before subprocedures, where they aren't allowed. It makes it really hard to use this precompiler for anything.
I'm hoping the latest PTFs will fix it...?
-SK
--
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@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
