Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Jean Sagi — — source: Usenet: comp.databases.informix
If you are on unix the you could use sh/ksh/bash to ask for your
variables and the dinamically build a sql script and execute it.
I used to that some time ago, it is limited but it works.
J.
Jonathan Leffler wrote:
> 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.
>
sending to informix-list
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.