RE: Using directives within Informix 4GL

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/

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/

Dang it! I pushed the wrong button. Sorry Stuart.... Madison Pruet wrote: > 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/