Re: SQL and reducing static storage

So basically, if you tried using a local variable by sql as in

p mysub b
d mysub pi
d mylocalvariable...

exec sql select column into :mylocalvariable from file where
key=:lockey;

then the precompiler would do something like duplicate mylocalvariable
into the main area, and then host that variable instead so it looked
something like
exec sql select column into :mainvariable from file where key=:lockey;
mylocalvariable=mainvariable;

Interesting. So the precompiler can now state they support local
variables, they just do it by using main variables and moving them back in
and out.

Rob Berendt