Re: Index

Hi, because there is no PREPARE statement available in SPL, you must use a fixed indexname. Sorry. Bye Stefan Weideneder PRAVEEN MOHANAN wrote: > > Hi...Users..... > > I am trying to create an dynamic index in a SPL. > The sequence is...I select a unique numeric value from a table & concat > it with a string and store it in a variable. > > Now how do i use this variable to create the index. I could do the > same using ESQL/C , but not successful with SPL. > > Eg. > LET index_name = 'index'||numeric_value; > > Create INDEX index_name on abc ........> > How do i substitue the variable name with its value. Whe i tried it > creates the index with the name = index_name. > > Thanks in Advance. > > Regards, > > Praveen > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com