> > From: Dalton Calford <dcalford@...>
>
> > I do not think that the metadata compiler should even check for the
> > presence of the remote database during metadata operations.

At 09:06 AM 3/8/2001 -0500, Craig Stuntz wrote:

> That's an interesting thought, because the implications are much
> larger.
>Doing this would mean the statements can't be optimized until runtime (even
>if the "remote" DB were accessible at design time, the index statistics
>might not reflect what will be in the "real" "remote" DB at runtime). And
>(optionally) deferring optimization to runtime might have other
>advantages -- the ability to build statements "on the fly" in a stored proc
>would be useful, for instance.

Optimization is done at run time. Compilation into BLR is done when
a procedure is defined, but BLR has no optimization. Compilation into



Regards,

Ann
www.ibphoenix.com
We have answers.