cleaning special characaters in char fields in db2

[donny]

any clue how to clean up special chars in char fields in db2 using datastage px

thanks in advance

[chulett]

And what do you classify as "special" characters?

[ArndW]

Also define your NLS settings for DB2 and DataStage and what you consider a cleanup to be (removing them, mapping them to other characters, etc.).

[donny]

actually the source is mainframe , ftp stage is used to get it to unix box first then CFF is used for translating and pushing data into sequential file.

[chulett]

And?

[ArndW]

That was an interesting post, donny. You managed to answer some questions that weren't asked but avoided answering any of the questions that were...

[donny]

after populating sequential file , data is transmitted thru transformer and loaded into db2

[donny]

after populating sequential file , data is transmitted thru transformer and loaded into db2

[donny]

i want to cleanup the special characters

[chulett]

Do you not realize that saying "special characters" is pretty much meaningless? Most of the time what people think are "special" or "junk" are just characterset conversion errors or perhaps ones they've never seen before and "cleaning" (as in removing/stripping) them may not be the appropriate response. Which is why Arnd made the statement he did.

So, without knowing what these characters are that you need help with, people can't really post appropriate answers. Any idea what characterset(s) are involved here, source and target? Can you give us some idea what unexpected characters it is you are seeing?

[Sairam]

Use this ecpression in Transformer it will replace any special characters with ''.

Code: Select all

if alnum(lnk.SrcCol) =0 then '' else lnk.SrcCol 

Let me know .[/quote]

[ray.wurlod]

Do you have the authority to unilaterally change your client's data?