Extracting data from DB2 table ~ character is missing

BMSK · Post by **BMSK** » Mon Jan 23, 2012 11:12 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Jan 23, 2012 11:59 pm

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?

pandeesh · Post by **pandeesh** » Tue Jan 24, 2012 1:54 am

in oracle we have dump() function to check the ascii value for each charcter in a string. Like that check is there any function available in DB2.

BMSK · Post by **BMSK** » Tue Jan 31, 2012 11:34 am

No this is entire string and stored in colum in table DB2. "pantai dalam ~ gilly valuey " when extract from table to file its comming "pantai dalam gilly valuey " tilda character missing.

DB2---->tran-----> seq

in transformer I checking null and empty value.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 31, 2012 2:49 pm

What we are asking is whether it's really a tilde in the data in the table, or some other character that displays as a tilde in some viewers.

BMSK · Post by **BMSK** » Tue Jan 31, 2012 8:45 pm

No its tilda in the table itself