Re: SQL0312 - in RPG compile.

On Aug 10, 2022, at 8:12 AM, Carel via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

Hi Vern,

Is some tme ago, but my negative experience was with a mix of fixed format D-specs with free format C-specs.

In the D-specs we defined the variables, in free format with embedded SQL we used those variables as receiving ones.

Got to loathe the SQL precompiler at that time.

Was to much hassle to rework the D-specs into D-specs.

(If IBM wants us to use embedded SQL so much, then get rid of those hidden errors that were not actiually there)

But I fear in complete free format this error may still occur. I do not trust the precompiler, as it is lacking in development.


Op 10-8-2022 om 13:40 schreef Vern Hamberg via RPG400-L:

Hi Carel

Do you have an example of an extra character after the file name in a free-form spec, that this raises an error? Like if there are 2 spaces between the name and "usage", say, or other keyword?

I do tend to use only single spaces there, just curious.

Cheers
Vern

On 8/9/2022 10:25 PM, Carel via RPG400-L wrote:

May still create the same error.


Op 10-8-2022 om 03:14 schreef Vern Hamberg via RPG400-L:

Time to use free-form file specifications!!

Vern

On 8/9/2022 9:54 AM, dfreinkel@xxxxxxxxxxxxxxxxx wrote:

I found my dumb error but I am surprised the editor did not highlight the
error. The F-Spec was 1 character out of position after the file name and
that caused the issue.

Once adjusted it compiled normally.

Thank you.
Darryl Freinkel
A4G
Telephone: 770.321.8562 Mobile: 678.355.8562

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Hiebert,
Chris
Sent: Tuesday, August 9, 2022 10:11 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: SQL0312 - in RPG compile.

SQL0312 Variable &1 not defined or not usable.

What variable?


You probably used a different compile command between the two programs.

Check RPGPPOPT(*LVL2) or the Date/time options.


Chris Hiebert
Senior Programmer/Analyst
Disclaimer: Any views or opinions presented are solely those of the author
and do not necessarily represent those of the company.

From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
dfreinkel@xxxxxxxxxxxxxxxxx
Sent: Tuesday, August 9, 2022 7:40 AM
To: 'RPG programming on IBM i' <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: SQL0312 - in RPG compile.


I need help with this one.





I have a program that worked for about a month. I renamed the RPG program

and display file, changing only the member names and therefor the program

names. No record formats were renamed. I did change the display file name in

the RPG program.





After renaming, the SQL precompiler fails with SQL0312.





I do not see a difference between the previous names and the renamed names

that should trigger the SQL0312.





Has anyone experienced this problem before and how did you resolve it?





TIA.





Darryl Freinkel



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

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

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

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