muralikrishnan_new
New User
Joined: 02 Jun 2013 Posts: 15 Location: India
|
|
|
|
Hi All,
I am trying to load a table which is having a data type as Graphic using the below mentioned JCL, I have referred the below link and created the Load parameters.
if I provide CCSID(1200)=UTF16 and input file records as UTF-16 format then the records are getting discarded with the following messages
Code: |
DSNU310I -DTC1 277 12:41:57.34 DSNURCON - RECORD (1) WILL BE DISCARDED DUE TO '
CONVERSION ERROR FOR CERATEST.CBTVZA01
ERROR CODE '17 - INPUT IS TOO LONG FOR A GRAPHIC'
DSNU310I -DTC1 277 12:41:57.34 DSNURCON - RECORD (2) WILL BE DISCARDED DUE TO '
CONVERSION ERROR FOR CERATEST.CBTVZA01
ERROR CODE '17 - INPUT IS TOO LONG FOR A GRAPHIC'
DSNU310I -DTC1 277 12:41:57.34 DSNURCON - RECORD (3) WILL BE DISCARDED DUE TO '
CONVERSION ERROR FOR CERATEST.CBTVZA01
ERROR CODE '17 - INPUT IS TOO LONG FOR A GRAPHIC'
DSNU310I -DTC1 277 12:41:57.34 DSNURCON - RECORD (4) WILL BE DISCARDED DUE TO '
CONVERSION ERROR FOR CERATEST.CBTVZA01
ERROR CODE '17 - INPUT IS TOO LONG FOR A GRAPHIC'
|
if I provide CCSID(1208)=UTF8 and input file records as UTF-8 format then the records are getting loaded but in table it is getting loaded with same UTF8 format as mentoned below
Code: |
TYPE(LEN) KEY COLUMN VALUE
---------- ---- ----+---10----+---20----+--
GRAPH(9) . . . . . . . . .
HEX UTF-16 333333333020202022
001000001000000000
GRAPH(2) .
HEX UTF-16 3302
0100
GRAPH(2) .
HEX UTF-16 3302
0100
GRAPH(1) .
HEX UTF-16 40
40
GRAPH(2)
HEX UTF-16 0202
0000
|
loadparm
Load utility reference
Code: |
//JE05630B JOB (C41,0000),'ONLINE LOAD IBMT BAS',
// COND=(4,LT),
// CLASS=TXBATU,
// MSGCLASS=6
//*
//DEFAULTS INCLUDE MEMBER=NI$BIB
// INCLUDE MEMBER=SI$TBIB
//S001 EXEC PGM=DSNUTILB,
// PARM='TDB2,,'
//STEPLIB DD DISP=SHR,DSN=SYS1.STEPLIB.DUMMY
// DD DISP=SHR,DSN=DB2TS.LIB.SATDB2.SDSNEXIT
// DD DISP=SHR,DSN=DB2TS.LIB.SATDB2.SDSNLOAD
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
LOAD DATA
INDDN SYSREC
UNICODE
CCSID(1208)
LOG YES
RESUME YES
SHRLEVEL NONE
ENFORCE NO
DISCARDS 0
FORMAT DELIMITED COLDEL X'3B'
INTO TABLE TDB2.CBTWDH01
/*
//SYSREC DD DISP=SHR,
// DSN=&USERID.JE05630.VZA01.UNLT01
//*
//SYSDISC DD DISP=(OLD,CATLG),
// SPACE=(CYL,(300,300),RLSE),DATACLAS=DCSEQE,
// DSN=&USERID.TMPN.DISC.CBSWDH01.T170919
//SYSUT1 DD DISP=(,DELETE)
//SORTOUT DD DISP=(,DELETE)
//SYSMAP DD DISP=(,DELETE)
//SYSERR DD DISP=(,DELETE)
//ODATEMPL DD DUMMY
//SYSOUT INCLUDE MEMBER=SISYSOUT
//ABNLNODP DD SYSOUT=*
//IMSERR DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//ELAPRINT DD SYSOUT=*
//ABNLNODP DD DUMMY |
Could you please help me to correct the load parameters to load the Graphic Data type data.
Thanks,
Muralikrishnan |
|