Index

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