Hi Friends,
Can anyone tell me how to perform conversion of string from one character set to another in DB2. I mean do we have anything equivalent to CONVERT function of Oracle in DB2.

What type of conversion? What does CONVERT in Oracle do?

please look at TRANSLATE function

convert is being used to translate characters from one character set to another. db2 does not have a similar function. ccsid is flagged at column level when you create the table. there are automatic convertion in known relations in the same character group.
there is no function to convert a ccsid.
translate only does a replacement of a character by another character but in the same character set.
Best Regards, Guy Przytula

If you do an export and import, DB2 will perform the character set converstion if they are compatible.

CONVERT
Syntax
convert::=CONVERT(attribute, dest_char_set, source_char_set)
Purpose
CONVERT converts a character string specified in an operator attribute from one
character set to another. The data type of the returned value is VARCHAR2.

The attribute1 argument is the value to be converted. It can of the data types
CHAR and VARCHAR2.

The dest_char_set argument is the name of the character set to which
attribute1 is converted.

The source_char_set argument is the name of the character set in which
attribute1 is stored in the database. The default value is the database character
set.
Both the destination and source character set arguments can be either literals or
columns containing the name of the character set. For complete correspondence in
character conversion, the destination character set must contain a representation of all
the characters defined in the source character set. When a character does not exist in
the destination character set, it is substituted with a replacement character.
Replacement characters can be defined as part of a character set definition.

Example
The following example illustrates character set conversion by converting a Latin-1
string to ASCII. The result is the same as importing the same string from a
WE8ISO8859P1 database to a US7ASCII database.
SELECT CONVERT('Ä Ê Í Õ Ø A B C D E ', 'US7ASCII', 'WE8ISO8859P1')
FROM DUAL;
CONVERT('ÄÊÍÕØABCDE'
---------------------
A E I ? ? A B C D E ?

Also , TRANSLATE function does not do character set conversion . It just translates one character to another of the same character set and not of different character set