Oninit cdi / Archive
Talk to an expert →

Re: *** HELP !!!

Posted in 1999

Carlson@WHSmith — — source: Informix-list mailing list archive (1991-1998)

Shouldn't that be . . . SELECT column[2, 4] FROM db1:table ... UNION SELECT column[2, 4] FROM db2:table ... ??? John Carlson Informix DBA WHSmith USA Juraj Buma wrote: > > Hi everybody! > > I'm using Informix-4GL version 7.20.UD7 on Linux and my problem is: > > SELECT db1:table.string[2, 4] > FROM db1:table > ... > > UNION > > SELECT db2:table.string[2, 4] > FROM db2:table > ... > > and during compilation folowing error occured in the first SELECT: > > db1:table.string[2, 4] > |_______________^ > | > | A grammatical error has been found on line 112, character 29. > | The construct is not understandable in its context. > | See error number -4373. > > What's wrong? Cannot select a part of string when using database name > prefix? > Please help !!! > > Juraj

Related threads