DSXchange

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

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?

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.

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.

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.

No its tilda in the table itself