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?