Re: Functions in a insert statement
Olcay Sarioglu wrote:
>
> What is wrong with the following SQL?
>
> insert into my_table values ( lower('AASDF') );
The INSERT statement is not designed to evaluate expressions.
> Can't we use functions in insert SQLs?
No.
> Informix Dynamic Server Version 7.30.UC5
But you can use them in SELECT statements. Maybe this would help you:
INSERT INTO my_table
SELECT lower('AASDF') FROM systables WHERE tabid = 1
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
|Mark D. Stock - Informix SA http://www.informix.com |//////// /|
|mailto:mdstock@informix.com http://www.informix.com/idn |///// / //|
|http://www.iiug.org +-----------------------------------+//// / ///|
| Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////|
| Fax: +27 838250 2325 |If it's fast, the users keep quiet.|// / /////|
|Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////|
+----------------------+-----------------------------------+-----------+