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 sup****t !
>
> 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,
|
