implied decimals
Posted: Wed Apr 21, 2004 9:09 am
In my project we are using flat files to interface with external systems.
In the interface layout specification, there are certain columns with an implied decimal&sign which need to be mapped to a decimal(10,2) field in DB2 using an ODBC stage.
I am not sure how to handle implied decimal fields so I was thinking of just dividing by 100 and then pasing the result but then I tried using the 'DataTypePic9V99' transform and it worked.
But now I need to do the reverse i.e. possibly export some fields which are of type DECIMAL(10,2) to a sequential file in an implied decimal format and am unsure how to do it and of what length it can potentially be (10 or 12) including the sign and implies decimal.
thanks in advance,
paul
Env: DS 7 on AIX
source: flat files, SQL Server, DB2
target: flat files, DB2
In the interface layout specification, there are certain columns with an implied decimal&sign which need to be mapped to a decimal(10,2) field in DB2 using an ODBC stage.
I am not sure how to handle implied decimal fields so I was thinking of just dividing by 100 and then pasing the result but then I tried using the 'DataTypePic9V99' transform and it worked.
But now I need to do the reverse i.e. possibly export some fields which are of type DECIMAL(10,2) to a sequential file in an implied decimal format and am unsure how to do it and of what length it can potentially be (10 or 12) including the sign and implies decimal.
thanks in advance,
paul
Env: DS 7 on AIX
source: flat files, SQL Server, DB2
target: flat files, DB2