Re: prepares in 9.2
Definatly no PREPARE. - otherwise we would never see "How can I write dynamic SQL in SPL" questions >>> <a_blonde@mindless.com> 05/11/00 03:14pm >>> ---- you wrote: > Also, do you know if there is a benefit from preparing sql used > repeatedly in a stored procedure? When sql appears in a stored > procedure, doesn't it automatically save the query plan for future > calls of the routine? If so, preparing sql in a stored procedure would > be useless. But there is no PREPARE command in SPL Dude. Not that I know of. AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com
"Richard Harnden (Richard harnden)" wrote: > Definatly no PREPARE. > - otherwise we would never see "How can I write dynamic SQL in SPL" questions > > >>> <a_blonde@mindless.com> 05/11/00 03:14pm >>> > ---- you wrote: > > Also, do you know if there is a benefit from preparing sql used > > repeatedly in a stored procedure? When sql appears in a stored > > procedure, doesn't it automatically save the query plan for future > > calls of the routine? If so, preparing sql in a stored procedure would > > be useless. > > But there is no PREPARE command in SPL Dude. Not that I know of. I think the dude is asking if there is any value to PREPARing a statement in an app that calls an SP since the SP is already optimized. I've personally never tested it so I cannot answer. Art S. Kagel