Re: Optimizer directives in 4gl

Posted in 2000

a_blonde@mindless.com — Thu, 11 May 2000 10:17:07 -0400 (EDT) — source: Informix-list mailing list archive (1991-1998)

---- you wrote: > Quick question for the 4gl experts: > > we are having trouble due to our 4gl program queries ignoring > optimizer directives. EXEC SQL SET EXPLAIN ON; shows directives > being ignored on prepared queries and cursors. > > We have an HP9000/Hp-Unix that uses informix 7.3 Dynamic Server. > > We would appreciate any help on how to go about figuring out > how to make the optimizer directives work. Eg, What environment > variables to start checking. Do we need a particular version of > 4gl for the directives to work? This usually menas you have a syntax error Dude. Show us the code you are using. AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com