Re: URGENT: Undocumented functions in isql

You need an upgrade to your manuals. TRUNC is documented. So is the concatenation operator ||. You just need sufficiently recent documentation. That means the Informix Guide to SQL for the current version of your engines -- the ISQL Manuals as such describe the Engines (and therefore the SELECT statement) as of Version 4.00, which, if I recall correctly, was released in 1990 and is verging on the archaic. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: sg@ivu-berlin.de (Stefan Gutsche) >Subject: URGENT: Undocumented functions in isql >Date: 8 Feb 1995 10:38:58 GMT >X-Informix-List-Id: <news.11384> >does anybody have a list of undocumented features in isql??? >I only know the function "trunc" and i recognize that someone >wrote here a SELECT-statement with a concat-function a few >days ago.