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.
Jack Parker — — source: Usenet: comp.databases.informix
Isn't there a DBLDFORMAT variable (or something like that) that dictates how numbers are formatted?
j.
Sane ego te vocavi. Forsitan capedictum tuum desit.
-----Original Message-----
From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of Floyd Wellershaus
Sent: Wednesday, February 13, 2008 11:14 AM
To: informix-list@iiug.org
Subject: selecting with thousands separator
Is there a way to select an integer or string value out of a table and have it display in this format xx,xxx ?
Thanks,
Floyd
Jack Parker wrote:
> Floyd Wellershaus asked:
>> Is there a way to select an integer or string value out of a table and
>> have it display in this format xx,xxx ?
>
> Isn't there a DBLDFORMAT variable (or something like that) that
> dictates how numbers are formatted?
I suspect you're thinking of DBFORMAT, but that is only supported by
I4GL and not by IDS.
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2007.0914 -- http://dbi.perl.org/
publictimestamp.org/ptb/PTB-2517 ripemd128 2008-02-14 03:00:07
E8275FB48AAA5A7A395429FB0FF9D7BD
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.