Can we use SPL logic like If .. then .. End if statements in SQL
Informix Script.

What we are trying to achieve is setting a variable in a script and
base on the value of this variable to create an index on different
tables.

We wouls like to know if there are such features in version 9.4

Thanx
Alexis

alexis.kyriakides@gmail.com wrote:
> Can we use SPL logic like If .. then .. End if statements in SQL
> Informix Script.

No.

> What we are trying to achieve is setting a variable in a script and
> base on the value of this variable to create an index on different
> tables.

That would require dynamic SQL in some form - SPL does not support
that unless you add the EXEC Datablade.

> We would like to know if there are such features in version 9.4

No - nor in 10.00.

Check out Marco's 4GLWORKS (http://www.4glworks.com/4glworks.htm).

(SQLCMD does not yet have such capabilities either. At least, not
directly. You could arrange to have one sqlcmd generate the data and
pipe the output into a second sqlcmd (possibly with an intervening
process such as sed or perl fixing up the syntax), but it is not
exactly what you were hoping for.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/