store procedure

hai, can any one tell me how will i create sql statements dynamically in store procedure. Thanks Nirmala --------------------------------- Yahoo! Personals Single? There's someone we'd like you to meet. Lots of someones, actually. Try Yahoo! Personals

You don't mention version, but as the product stands, you can't build dynamic sql in stored procedures. If you are on version 9.x or 10, you can look for the dynamic sql bladelet. You can probably find it on www.iiug.org in the software repository. > hai, > can any one tell me how will i create sql statements > dynamically in store procedure. > > Thanks > Nirmala

hi nirmala, how are you? i hope u r doing well? this is same pgm which u can see the stored procedure CREATE PROCEDURE test ()DEFINE count INT; BEGIN TRACE `starting test procedure'; TRACE ON; WHILE count < 100 LET count = count + 1; END WHILE TRACE OFF; TRACE `Finished test procedure'; TRACE `Last count value is ` || count; if u not able to understand please write to me. which r u working? thanks ramanathan On Wed, 07 Dec 2005 Nirmala Kes.... wrote : >hai, > can any one tell me how will i create sql statements > dynamically in store procedure. > > Thanks > Nirmala > > >--------------------------------- > Yahoo! Personals > Single? There's someone we'd like you to meet. > Lots of someones, actually. Try Yahoo! Personals