Numeric to character - Connect_CDC - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

Method: Numeric to character

Function name:   tostring

Parameter list:   (DOUBLE input)

Return type:   CHAR

What the method does:    Converts a numeric (decimal, float, integer) in the source column to a character in the target column.

Converts a numeric (decimal, float, integer) in the source column to a character in the target column.

A float datatype (float or double) is displayed with scientific notation output when you use the Data Enhancement method “Numeric to Character”. For example, what is seen in the source as 1654860672 is replicated to a target as 1.654860672E9.

If you do not want scientific notation output for a float number, then use the following expression:

   tostring( tointeger(<float_number>) )

This first converts the float approximate number to an exact integer and then to a character string.