Re: optimization-goal directive

Posted in 1999

a_blonde@mindless.com — Thu, 26 Aug 1999 10:26:35 -0400 (EDT) — source: Informix-list mailing list archive (1991-1998)

---- you wrote: > running ver 7.3 IDS . 7.20 RDS > > FIRST_ROWS Syntax works fine under dbaccess , but causes syntax error under > RDS. Is it just me or does RDS does not like "optimization directives ", if > so does anybody know if it will in the future. > > Please tell me it is me . Dude, it is not you. It appears that PREPARE does not like the ANSI standard comments, but DOES like the SQL comments. So instead of using '--', embed your directives in '{}' and it will work. Wierd! Maybe JL can explain this if he is not still mad at me. AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com