Hi Vijay,
in db2 we have to use substr function
Example:select substr(empid,2,len(empid)) from schemaname.tablename;
try this one
hope it will help you.
if iam wrong correct me
thanks
fareeda
Remove special characters ...
Moderators: chulett, rschirm, roy
The substr() function in DB2 only helps if you know the actual location of the characters to replace.
In DS you can use the convert() function to convert certain characters to others (or to empty); but this list might be a long one unless you only have a limited number of special characters.
Do you just have those characters to be replaced, or do you wish to replace everything outside of the standard latin displayable character set?
In DS you can use the convert() function to convert certain characters to others (or to empty); but this list might be a long one unless you only have a limited number of special characters.
Do you just have those characters to be replaced, or do you wish to replace everything outside of the standard latin displayable character set?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
What tool are you using to see this extra character? In the sequential file output stage, what have you set in the format for line, field and record terminators?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>