DSXchange

one question:
if i don't enable NLS, can I do what as PhilHibbs post?

Thank you very much - that code worked! My target is a sequential file.
I really appreciate your help!
Thanks,
Barbara

Hello, I am having a problem with the display of zero as 0, yet I want it to display as 0.00. I have tried the results of other postings, with no success. I have switched datatypes, suppressed zeroes, converted to a double or float, if-then-else, etc. - but it is still not working. In the transforme...

Hello, I am having the same problem. I have tried to "switch the datatype and suppress the zeroes", but it is still not working. In the transformer: Input: Decimal 38,2 Stage Variable: Decimal 38,2 Output: Varchar 40 with a DecimalToString(COLUMN_NAME_HERE,"suppress_zero") conver...

I tried both Sequencial and Complex Flat File stage to transform EBCDIC file into ASCII file. It works well for transforming char. But it will always get import error when transforming packed decimal. For example, the packed decimal 27 0f in the EBCDIC file is supposed to be transformed into decimal...

could you please give more details?

one question:
what if there is no records come from the last stage, how to generate the 0,0,0,0,0 line