Re: Informix external directives ?

Joerg Rueschenschmidt wrote: > 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 This is funny... I was interested in your situation, mostly because I never used the external directives, so I was trying to get some time to test it. But today, I got a situation where they may be useful, and I tried them... Without success... So, I thought you were right... But then, I come here for the usual daily check and I see that it works, and after checking the PMR, I confirmed that I tried a similar situation... Now, since it does work, but it didn't work for me, I'll have to re-check my tests :) Anyway, thanks for posting! Regards,