I would like to remove the decimal point from the column.

For example, D21.3 would become D213

Someone help me, please.

CodePudding user response：

If you are using DataStage 9.1 or above, try:

Ereplace(ColumnName, ".", "")

CodePudding user response：

In Netezza

=> select translate('D21.3','.','');
 TRANSLATE
-----------
 D213