Re: sql select without editing numbers

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Jim

I have to ask what tool you are using to run the SELECT - I don't 
usually see commas when the columns are numeric. Here're the results for 
1 row of QIWS/QCUSTCDT -

CUSNUM 	LSTNAM 	INIT 	STREET 	CITY 	STATE 	ZIPCOD 	CDTLMT 	CHGCOD 
BALDUE 	CDTDUE
938485 	Johnson 	J A 	3 Alpine Way 	Helen 	GA 	30545 	9999 	2 	3987.5 	33.5


CUSNUM, ZIPCOD, CDTLMT, and BALDUE are all Numeric

*Regards*

*Vern Hamberg*

<cid:part4.i2taBQ1w.k6cbi0o0@centurylink.net>

On 2/12/2025 3:05 PM, Charles Wilt wrote:
> DIGITS(ORDER)
>
> HTH,
> Charles
>
> On Wed, Feb 12, 2025 at 1:46 PM Jim Franz<franz9000@xxxxxxxxx> wrote:
>
> > I'm sure its a simple thing, but i need the Order column numbers to not
> > have commas (user requests like  2450245). DDS defined tables, packed 7,0
> > Google full of hacks that db2 doesn't do.
> >
> > CUST    TRAN_CODE                ORDER   Ref
> > ESW01       25               2,450,245   Widgets
> > ESW01       25               2,453,785   Bolts
> >
> > when i use varchar_format it pads spaces to the right of column and trim
> > seems to be ignored
> > tia
> > Jim Franz
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> > To post a message email:MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit:https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > athttps://archive.midrange.com/midrange-l.
> >
> > Please contactsupport@xxxxxxxxxxxxxxxxxxxx for any subscription related
> > questions.