Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
ds_raman
Participant
Posts: 21 Joined: Tue Nov 27, 2007 3:10 pm
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
Thanks and regards
raman
miwinter
Participant
Posts: 396 Joined: Thu Jun 22, 2006 7:00 am
Location: England, UK
Post
by miwinter » Mon Jun 08, 2009 5:49 am
Are you converting the datatype between read and write?
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Jun 08, 2009 6:40 am
Kindly explain what you mean by 'special' characters.
-craig
"You can never have too many knives" -- Logan Nine Fingers
ds_raman
Participant
Posts: 21 Joined: Tue Nov 27, 2007 3:10 pm
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
Thanks and regards
raman
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
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.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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?
-craig
"You can never have too many knives" -- Logan Nine Fingers