RE: Using directives within Informix 4GL

Ah, the day has not been wasted. I supose you'd need to prepare a string then, just like the man says. -----Original Message----- From: Madison Pruet [mailto:mpruet@home.com] Sent: Tuesday, January 30, 2001 12:46 PM To: informix-list@iiug.org Subject: Re: Using directives within Informix 4GL Stuart, I'm not posting this on comp.databases.informix. The --+ordered optimizer directive does not mean the same as "ordered by". It means scan the joined tables in the same order that they appear in the 'from' clause. Stuart Hogg wrote: > In 4GL -- can signify a comment. The "--+ordered" is being > ignored by the compiler. If you want to order the results > use an ORDER BY clause at the end of the query. > > l8r.. > > -----Original Message----- > From: Paulo Amorim [mailto:pauloamorim@uol.com.br] > Sent: Monday, January 29, 2001 5:10 PM > To: informix-list@iiug.org > Subject: Using directives within Informix 4GL > > Does anybody knows how to use directives within an Informix 4GL program > ?? > > What I want to do is a query like this: > > select --+ordered > * from a,b,c > where a.a = b.b > and b.b = c.c > > The directive is not followed when the query runs. I can see that when > I use onstat -g sql or when I use sqexplain. > > Is there any other special syntax to be used ??? > > Thanks > -- > Paulo Roberto Marelli de Amorim > TS&0 Consulting > Brasil > > Sent via Deja.com > http://www.deja.com/