Integer to Double

[major]

Dear all,

Is there any function in Data stage which will convert the integer data type to double data type.
I am loading data to a sequential file from a set of input Hashed files , the data type in input hashed files is int , i want that data in the output sequential file to be double data type.

Will sequential file differentiate int and double data types?

Please share your thoughts.

[chulett]

Server isn't strongly typed like PX so there isn't much in the way of conversion functions to be had - or needed. Never mind the fact that flat files have no data types, only 'character' fields when you get right down to it.

[ray.wurlod]

Server jobs don't really have data types at all, just three data classes - numeric, non-numeric (string) and null.

Numeric is quite flexible, and includes "scientific notation" e.g. 6.023E23 for exponents up to maybe 38. So even if your source number is too large to be an integer, a server job can still identify it as numeric.

The Num() function reports whether a string may be classed as numeric.

[major]

Thank you all