I usually use MS SQL Server, but am working on a project where I also
have to integrate with a legacy Informix box.  I do not have write
priveleges to the Informix box, just read only, so I cannot create a
stored procedure.  Basically what I want to do is insert text into my
query results (I know, it would be better to do this in the handling
code on the back end, but I want to see if this can be done).  The code
I use for MSSQL is this:

DECLARE @customstr2 CHAR(4)
SELECT @customstr2 = '.tif'
DECLARE @customstr4 CHAR(40)
SELECT @customstr4 = 'some other text'
SELECT imageid, patid, datecreated, lname, facname, @customstr2 as
customstr2, @customstr4 as customstr4 from imagetable where
imgindex='12345'

I have done some searching and have found that the sql code for
infomrix may look like this, but it doesn't work:

DEFINE CHAR customstr2[4] = ".tif";
DEFINE CHAR customstr4[40] = "some other text";
SELECT imageid, patid, datecreated, lname, facname, customstr2 as
customstr2, customstr4 as customstr4 from imagetable where
imgindex='12345'

Any hints?