Load from AS400, record with special character

le thuong · Post by **le thuong** » Thu Jul 31, 2014 10:43 am

my job reads a DB2 table via ODBC and writes to an Oracle table (Oracle connector). some records with column (data type Char) containing special character x'6A' (EBCDIC broken vertical line) get rejected (ORA-12899: value too large for column). Your input is welcome.

chulett · Post by **chulett** » Thu Jul 31, 2014 11:19 am

So just your typical characterset issue with multibyte data going into (I assume) Oracle fields defined using byte semantics. How are each field defined, source and target? Specifically wondering if you are writing to a CHAR(n) where it is actually defined as CHAR(n BYTE).

le thuong · Post by **le thuong** » Thu Jul 31, 2014 1:38 pm

Source (DB2) and target (Oracle) have same column definition, char(10) in this case.

chulett · Post by **chulett** » Thu Jul 31, 2014 1:53 pm

Which unfortunately doesn't answer my question on the Oracle side... check with your DBA if you're not sure of the difference in semantics. I'll wager DB2 is set to 10 characters and Oracle is set to 10 bytes.

le thuong · Post by **le thuong** » Fri Aug 01, 2014 3:40 am

You are right. I have redefined my target Oracle column as Char(10 char) instead of Char(10), and the data are correctly loaded. Thanks a lot.