Re: OPTIMIZER DIRECTIVES IN 4GL
Use PREPARE statement...
Best regards,
Danail.
-----Original Message-----
From: Jorge Lopez <pepe@intersil.es>
To: informix-list@iiug.org <informix-list@iiug.org>
Date: 21 '''''''' 1999 '. 10:24
Subject: OPTIMIZER DIRECTIVES IN 4GL
>Hello.
>
> I can use optimizer directives from dbaccess / Query Language, but
>they don't work in a 4gl-program.
> The engine is IDS 7.30.UC2-1 and RDS-4GL is 7.20.UD7 on a SCO
>OpenServer 5.0.5.
>
> Example:
> select {+INDEX (tablename indexname)} *
> from tablename
>
> I look the 4gi file of the program with hd utility, and I can see
>the sql statement, but the optimizer directive has disappeared.
>
> Thanks !!
>
>
>
>
>