How can handle multiple lines into a single line in data sta

[bikan]

Hi,

My source coming from access database in that table one field contain multiple lines data that field data type is memo in access same i transformed into target(DB2) but in target stored before and after data stored some junk values how can i handle in data stage and which fuction will usefull.

[ArndW]

A memo field can store a string up to 65,536 bytes. It is just a long string field and if you define your DB/2 column large enough there should be no problem storing that data. What do you mean by "junk" characters? If the incoming data has binary control characters that are not displayable then the target will have the same characters.