INSERT statement

Posted in 2000

Michael O'Sullivan — Tue, 18 Apr 2000 10:25:07 +0100 — source: Informix-list mailing list archive (1991-1998)

It appears that the INSERT statement is very restrictive as regards it's calling convention. When I try to use the TO_DATE or NVL, DECODE functions etc within the INSERT I just get a syntax error. It seems that you cannot call other Informix functions within an INSERT unlike Oracle/Sql Server. Is this true? Does anyone know of possible workarounds? IDS v7.31 WinNT4 Thnaks, Michael.

↪ replying to Michael O'Sullivan

Yuri Dovgart — Tue, 18 Apr 2000 15:24:48 +0400 — source: Informix-list mailing list archive (1991-1998)

Michael O'Sullivan <MichaelOS@peregrine.ie> wrote in message news:8dh9fh$mfd$1@kermit.esat.net... > It appears that the INSERT statement is very restrictive as regards it's > calling convention. When I try to use the TO_DATE or NVL, DECODE functions > etc within the INSERT I just get a syntax error. It seems that you cannot > call other Informix functions within an INSERT unlike Oracle/Sql Server. Is > this true? Does anyone know of possible workarounds? You can't use functions in INSERT statement. There is no workaround. -- ------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Informix Certified Professional, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284285 > > IDS v7.31 WinNT4 > > Thnaks, > Michael. > >