RE: Qualifying table & field names

Posted in 1999

Tino Cremidis — Thu, 19 Aug 1999 13:54:30 -0400 — source: Informix-list mailing list archive (1991-1998)

Terry, You need to set the environment variable: DELIMIDENT export DELIMIDENT=1 HTH Tino > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Terry Sharp > Sent: Thursday, August 19, 1999 12:32 PM > To: informix-list@iiug.org > Subject: Qualifying table & field names > > > When performing a simple select with qualified table and field names (e.g. > select "person"."id" from person) I get a syntax error. This > works fine if > I take out the quotes. Is there a setting or config parameter that I can > change so that Informix Dynamic Server 7.3 will let me qualify my > table and > fields. > > This same SQL statement works fine in oracle and ms sql server. > > TIA > > -- > Terry Sharp, Data Architect > Witness Systems, Inc. > ph: 770-754-1911 > fax: 770-754-1888 > tsharp@witsys.com > >