Hi
When i display the numeric fields in the output , it displays as 2,000.
Examle
2000 =2,000
2345 = 2,345

i am using the format like that

TABLE FILE SQLOUT
PRINT
AMOUNT/D20CBM AS AMOUNT
END

so my output will be 2,345 like that

My requirement is my output should be without the semicolon
like 2000,2345

Please help me to solve the issue.


Thanks
Gobinath Velusamy

Gobinath,

Try something like this...

  
TABLE FILE CAR
PRINT
     DEALER_COST
     DEALER_COST/D7c

END

For DEALER_COST/D7c the lower case c suppresses the comma.

Sayed

First , is a comma and not a semi-colon.

If your numeric output is double precision floating point, 'D', then the format defaults to C, ie the comma is included; but if you over-ride that with c then the comma is suppressed.

quote:

AMOUNT/D20CBM AS AMOUNT

FYI! Try this for your case with lower case c.

AMOUNT/D20cBM AS AMOUNT

Additionally, you may search the Technical Documentation Library using 'numeric display options' as a search argument for much more info.

You can enter the library from the upper right of this screen.

1. You mean a ',' and not a ';'
2. Lower 'c' as stateD will suppress comma
3. Try using 'P' format instead of D, although calculation results may vary.

Ira
aix-533 WF 537

If you are wanting to save this with a comma between the values, the output format should be COMMA.