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.
Integer to Double
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.