Skip to main content
Skip table of contents

Convert numeric values with CVTDBXLS with currency symbol

To convert data from a database to Excel so that the currency symbol appears, the DFNSTYLES and APPSYLES parameters are to be used as follows: 

(Here the OZAPROR column is formatted with the "EURO" style defined in the DFNSTYLES parameter).

CODE
CVTDBFXL FROMFILE(<mylib>/<myfile>)
TOSTMF('/tmp/test')
DFNSTYLES((EURO *NO *NO *GENERAL *NONE *BOTTOM *DFT
*NO *AUTOFIT *ARIAL 10 *NO *NO *NO *AUTO
*NONE *AUTO *NONE *NONE *AUTO *CUSTOM *F
IELD *FMT *FMT *FMT *FMT '#,##0.00€;-#,##
0.00€'))
APYSTYLES((*FLDNAM OZAPROR EURO))
EXCEL(*XLSX)




JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.