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)