Re: Functions in a insert statement

Posted in 1999

Vardan.Aroustamian@chase.com — Fri, 19 Feb 1999 10:06:31 -0500 — source: Informix-list mailing list archive (1991-1998)

Olcay Sarioglu <olcay@knidos.cc.metu.edu.tr> wrote: > > What is wrong with the following SQL? > > insert into my_table values ( lower('AASDF') ); Besides constants you can use only certain keywords (NULL, CURRENT, USER, DBSERVERNAME, TODAY) in 'values' part. > > Can't we use functions in insert SQLs? You can. But in select :) insert into my_table select lower('AASDF') from systables where tabname = 'systables'; > > Informix Dynamic Server Version 7.30.UC5 > > == Olcay Sarioglu > > Vardan -- vaar@geocities.com