Re: Informix external directives ?

Posted in 2008

Joerg Rueschenschmidt — Wed, 16 Jul 2008 15:42:32 +0200 — source: Usenet: comp.databases.informix

Joerg Rueschenschmidt schrieb: > Hi all, > > Is it possible to use Informix external directives for statements with > host variables ? > > It works fine for statements without host variables. > > Now, I need to solve a problem for a statement with a host variable. > > e.g. > > ... WHERE (a0.t_ncst > ?) > > If I add a statement with host variables my directive is not used :-( > > I am afraid that I can not benefit from external directives if host > variables are used. > > Can someone confirm this ? > > Regards ... > > Joerg fyi. Informix external directives are working with host variables. It was my fault. I added FIRST_ROW instead of FIRST_ROWS as directive. One character can have a big influence. Thanks to Informix support ! Regards ... Joerg