Unloading Data from DECIMAL(n,0) Columns using DSNUTILB

prathmone · New User Joined: 31 Jan 2022 Posts: 2 Location: Germany

Hello All,

Can someone help me with the below issue -
While unloading data from DB2 tables using DSNUTILB utility, in case of COLUMNS with datatype DECIMAL(n, 0), there comes an extra '.' in the unloaded data.

How can we get rid of this extra '.'

Unload JCL -
//STEP1 EXEC PGM=DSNUTILB,PARM='TDB1'
//STEPLIB DD DSN='TEST.SDSNLIB',DISP=SHR
//SYSREC DD DSN=TEST.INPUT.TABLE1,
// DISP=(NEW,CATLG,CATLG),
// UNIT=SYSDA,SPACE=(TRK,(2,1))
//SYSPUNCH DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN DD *
UNLOAD DATA
FROM TABLE TABLE1
DELIMITED CHARDEL '"' COLDEL ','

Table Defination-
COL1 DECIMAL (1,0),
COL2 CHAR (3)

Current Unload -
1.,"ABC"
2.,"DEF"
3.,"GHI"

Expected Unload -
1,"ABC"
2,"DEF"
3,"GHI"

sergeyken · Posted: Wed Mar 09, 2022 1:46 am

Joerg.Findeisen · Posted: Wed Mar 09, 2022 2:32 am

sergeyken · Posted: Wed Mar 09, 2022 2:46 am

sergeyken · Posted: Thu Mar 10, 2022 12:16 am

No reaction from TS (as usually...)
Keine Reaktion vom Themenstarter (wie üblich..)

prathmone · New User Joined: 31 Jan 2022 Posts: 2 Location: Germany

Ganz Herzlichen Dank sergeyken und Jörg.Findeisen !
Entschuldigung für die späte Antwort.

Pandora-Box · Posted: Tue Apr 26, 2022 1:31 am

Can you try DIGITS(col1) in your unload statement

Untested