Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)
Pawel Stepniowski wrote:
>
> Hallo,
>
> I have problem. I need to convert numerical value ( integer in fact ) to
> text, and I need to do it is select statement. I was looking in FAQ's
> and other sources and I couldnt find
> any suitable informix function. I don't want to write any stored
> procedure (this is not my idea). I know that this slow down performence
> etc. etc.
Informix will return data in any format that it can properly convert
the column into. What front end tool are you using? What output
format do you need?
For example to get text from dbaccess/isql just 'UNLOAD TO file...'
or 'OUTPUT TO file ...' the output will be text. In 4GL or ESQL/C
you can just select the column into a 'char' type host variable or
in ESQL/C you can describe the statement and then just change the
type of the column in the sqlda structure or descriptor area (being
sure to allocate enough memory to hold the text).
If you need more help, please be more specific.
Art S. Kagel
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.