Hi All,
I am extracting data from table DB2. for one of the colum I defined as char. while extracting the ~ character its excludes.
pantai dalam ~ gilly valuey -----> pantai dalam gilly valuey
its skipping ~ value. I need ~ charatcter in Outputcolum.
Please help on this.
thanks
bmsk
Extracting data from DB2 table ~ character is missing
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
First question - is this really a tilde character, or just a representation on the client of some other character? Use a hex conversion function when extracting from the database table to determine what the character actually is. Once you've determined that, post back and we'll try to work out why it disappears. If it were a genuine (printable) tilde character it would not disappear. Or is there something in your job design that you're not telling us about?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: