Re: optimization-goal directive

---- you wrote: > The Mindless Blonde <a_blonde@mindless.com> also asked: > > 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. > > JL is still a trifle piqued by some of your mannerisms, and some of > your responses to one of my answers, but will probably get used to > seeing 'dude' scattered around your postings. Mad, piqued, what's the diff Dude? > As to why PREPARE doesn't recognize -- style comments, I'm curious to > know how you put the newline into the strings to terminate those > comments. At least, that's my starting point for questions. And you need go no further Dude. Nail's head hurts. > The > normal technique of building a query doesn't work: > > LET stmt = "SELECT --+ optimizer hint ", > " * FROM SomeWhere WHERE SomeCondition" > > The stmt consists of SELECT and a lot of comment; the comment extends > up to the first newline or the end of string. Gotcha! So now I have the solution: LET stmt = "SELECT --+ optimizer hint ", ASCII 10, " * FROM SomeWhere WHERE SomeCondition" Thanks Mr L. AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com