Re: NULL generating "Sintax Error"

Preetinder, To do this I would have to alter the code of all my programs. I support a system comprised of a few dozen executables that run fine with other RDBMs (such as Oracle, SQL Server and Sybase) through ODBC. Now this system is being certified to Informix. We were hopping to port the system with a minimal change in code. Jorge Preetinder Dhaliwal <preetinder.dhaliwal@dhl.com> wrote in message news:<bd699h$nu1$1@terabinaries.xmission.com>... > Why dont u use "" instead of null?? as informix anyway does not know > which kind of null ( if u r using into clause ). This will save time > over calling a function. > > Rgds > Preetinder > > Fernando Nunes wrote: > > > Jorge Vergara wrote: > > > Hello All. > > > > > > The query bellow generates a sintax error: > > > SELECT 'ADP' > > > , '!' > > > , null > > > , '6.1.1.06' > > > #^ > > > # 201: A syntax error has occurred. > > > # > > > > Use "null()". It's created by a script in $INFORMIXDIR/etc > > > > Regards > > sending to informix-list