cleaning special characaters in char fields in db2
Moderators: chulett, rschirm, roy
cleaning special characaters in char fields in db2
any clue how to clean up special chars in char fields in db2 using datastage px
thanks in advance
thanks in advance
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.).
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Re: cleaning special characaters in char fields in db2
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.
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...
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
special chars
after populating sequential file , data is transmitted thru transformer and loaded into db2
special chars
after populating sequential file , data is transmitted thru transformer and loaded into db2
Re: special chars
i want to cleanup the special characters
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?
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?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Use this ecpression in Transformer it will replace any special characters with ''.
Let me know .[/quote]
Code: Select all
if alnum(lnk.SrcCol) =0 then '' else lnk.SrcCol
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: