Page 1 of 1
cleaning special characaters in char fields in db2
Posted: Wed Mar 31, 2010 8:38 am
by donny
any clue how to clean up special chars in char fields in db2 using datastage px
thanks in advance
Posted: Wed Mar 31, 2010 9:24 am
by chulett
And what do
you classify as "special" characters?
![Confused :?](./images/smilies/icon_confused.gif)
Posted: Wed Mar 31, 2010 9:35 am
by 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.).
Re: cleaning special characaters in char fields in db2
Posted: Wed Mar 31, 2010 9:49 am
by 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.
Posted: Wed Mar 31, 2010 10:00 am
by chulett
And?
Posted: Wed Mar 31, 2010 10:04 am
by 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...
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
special chars
Posted: Wed Mar 31, 2010 12:40 pm
by donny
after populating sequential file , data is transmitted thru transformer and loaded into db2
special chars
Posted: Wed Mar 31, 2010 12:41 pm
by donny
after populating sequential file , data is transmitted thru transformer and loaded into db2
Re: special chars
Posted: Wed Mar 31, 2010 12:43 pm
by donny
i want to cleanup the special characters
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
Posted: Wed Mar 31, 2010 1:26 pm
by 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?
![Confused :?](./images/smilies/icon_confused.gif)
Posted: Wed Apr 28, 2010 11:19 am
by 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]
Posted: Wed Apr 28, 2010 5:01 pm
by ray.wurlod
Do you have the authority to unilaterally change your client's data?
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)