Re: SQL SELECT displaying commas in numerics

[CRPence <CRPbottle@xxxxxxxxx>]

Dan wrote:
> In interactive SQL, numerics by default display with commas for the 
> thousands separator.  Is there a way to lose the commas?
>
> Note that I'm using SELECT * FROM CUSTMAST, and I really don't want
> to list every field in the file to have to use DIGITS(CUSTNO).
>
> I looked at changing the session attributes (F13), where you get
> choices for the decimal point, and for date & time format /
> separators, but nothing for thousands' separators.

  If CUSTMAST is created from DDS, then specify an Edit Word [EDTWRD] 
or Edit Code [EDTCDE] on the DDS for the field; editing which does not 
include thousands separators.  And although that will assist with the 
Query/400 report writer [which is the report writer for *LOCAL displayed 
and printed reports], changing the field editing will unlikely have any 
effect on\for output from other report writers.

  There is also a message CPX2D06 which defines the /default editing/ 
for fields that have no editing in the DDS.  IIRC there is something 
like a 4=*NONE for thousand separator in the /editing/ option for a 
field definition in WRKDTADFN.  Best to use your own message file and 
OVRMSGF QCPFMSG TOFILE(yourMSGF), after having done a MRGMSGF of the 
selected message; i.e. change only a copy of the message, as changes to 
the original could cause serious errors. 
http://www.google.com/search?hl=en&q=cpx2d06

Regards, Chuck