Re: RPG SQL precompiler

The difference between *LVL1 and *LVL2 is that *LVL2 will
expand the /INCLUDE directive as well as everything *LVL1 does.

Please keep in mind that the precompiler does not have a
concept of scoping. My guess is that the global variable
you are using in the subprocedure is also defined in a
different subprocedure. The precompiler is finding two
variables with the same name. There are some exceptions
to be able to use variables that are defined multiple times,
but is is recommended to use a unique name.

date: Tue, 19 Jun 2007 18:44:17 +0200
from: "David Foxwell" <david.foxwell@xxxxxxxxx>
subject: RPG SQL precompiler

Hi,

I have some global variables coded by /COPY QRPGLESRC MyVars

I'm compiling with CRTSQLRPGI RPGPPOPT(*LVL1) -tried *LVL2 but don't

understand the difference.

When I try to use one of these variables as a host variable in an EXEC SQL

in a subprocedure I get the message SQL0312 that the variable >isn't
declared.

I'm having to declare another variable in the main program source.