Special characters being truncated in API Stage

ds_raman · Post by **ds_raman** » Mon Jun 08, 2009 5:44 am

I have a character 8 field, which has special characters at mainframe source, but when these values are being loaded to the db2 tables, the special characters are truncated even though i am not using any trim functions.

Kindly update me on the issue

miwinter · Post by **miwinter** » Mon Jun 08, 2009 5:49 am

Are you converting the datatype between read and write?

chulett · Post by **chulett** » Mon Jun 08, 2009 6:40 am

Kindly explain what you mean by 'special' characters.

ds_raman · Post by **ds_raman** » Mon Jun 08, 2009 10:10 pm

chulett wrote:Kindly explain what you mean by 'special' characters. ...

They look like this

ZI I cS
ZI I S
ZI I cS
ZI I /S
ZI #I cS

ray.wurlod · Post by **ray.wurlod** » Mon Jun 08, 2009 10:37 pm

And what actual characters ARE they? How are they encoded? (For example they are not characters encoded in the set of ASCII code points.)

chulett · Post by **chulett** » Tue Jun 09, 2009 5:36 am

Using a hex editor or a dump of the file ("od -x") can you ascertain what the actual underlying hex values of those characters are?