Skip to main content

xdb DSNUTILB LOAD ascii dataset

  • June 26, 2018
  • 0 replies
  • 0 views

Hi,

I have a xdb database with location created "ascii sensitive", after load with DSNUTILB I view the char column with EBCDC value,

while decimal column is ok.

the input dataset is ascii with decimal data in COMP-3 format, and load is made without syspunch.

Is normal?  How can I solve?

ES:

load step:

//LOAD0001 EXEC PGM=DSNUTILB,REGION=8M
//STEPLIB DD DISP=SHR,DSN=SYEX.DB2T.SDSNEXIT
// DD DISP=SHR,DSN=SYEX.DB2T.SDSNLOAD
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSUT1 DD DSN=&SYSUT1,
// DISP=(NEW,DELETE,DELETE),UNIT=SYSDA,
// SPACE=(CYL,(242,300))
//SORTOUT DD DSN=&SORTOUT,
// DISP=(NEW,DELETE,DELETE),UNIT=SYSDA,
// SPACE=(CYL,(242,300))
//SYSMAP DD DSN=&SYSMAP,
// DISP=(NEW,DELETE,DELETE),UNIT=SYSDA,
// SPACE=(CYL,(5,50))
//SYSDISC DD DSN=TEMP3.SYSDISC.D3PM001A.SPM2010,
// DISP=(MOD,DELETE,CATLG),UNIT=SYSDA,
// SPACE=(CYL,(15,90))
//SYSERR DD DSN=&SYSERR,
// DISP=(NEW,DELETE,DELETE),UNIT=SYSDA,
// SPACE=(CYL,(5,50))
//ERROR DD SYSOUT=*
//SYSREC DD DISP=SHR,DSN=M4.FMT.LVOXEN30.LXXBR90T.ROPI
//SYSIN DD *
LOAD DATA REPLACE INDDN SYSREC
LOG NO RESUME YES
INTO TABLE M400.TBIOBIX

thank 

bye


#EnterpriseDeveloper
#xdbasciiDSNUTILB

0 replies

Be the first to reply!