Re: Informix Script Language
This is a discussion on Re: Informix Script Language within the Informix forums, part of the Database Server Software category; --> If you are on unix the you could use sh/ksh/bash to ask for your variables and the dinamically build ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 08:38 AM
| ||||
| ||||
 Re: Informix Script Language 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      |
Linear Mode
