Re: Informix external directives ?

Dirk Gunsthövel schrieb:
> Hi,
> 
> after testing Joergs case and some other cases
> (using version 10.00) I came to the comclusion that
> 
> 1. Joerg is right. External directives dont work with
> prepared statements
> 
> 2. The whole external directives thing only works
> if you are dealing with a statement that is 100%
> the same every time you run it.
> 
> If your Application queries for lets say
>   SELECT * FROM sometable WHERE name='Joerg'
> you will not be able to optimize the statement where
> 'Joerg' is exchanged with lets say a user input tomorrow.
> 
> If this is true external directives are not usable in
> 99,9% of the cases where you would like to use them.
> 
> ... i.e. the whole concept is good for (nearly) nothing -
> something that sounded cool in the tech conferences
> where I heard about it but fails when you try it.
> 
> Maybe I missed something here (or maybe it is doing
> better in a version >10?). Could someone please
> comment on this?
> 
> Regards,
> Dirk
> 

Thanks Dirk for your investigation. I will open a PMR to get an offical 
answer from IBM. I will share the result to you.

Regards ...

Joerg