Re: SQL and reducing static storage

[rob@xxxxxxxxx]

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