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
270
in ASCII. But I got the log below:
Field "col1" has import error and no default value; data: {
' 0f
}, at offset: 0
Is there something wrong when importing the file? (
'
is the ASCII character for 27). I have already set the character set to EBCDIC.
Packed is packed and is neither ASCII nor EBCDIC. So while you do indeed need to convert character data as you've noted, packed fields need no such thing, and any 'conversion' will destroy them. You s ...
It's a scheme of devices to get at low prices all goods from cough mixtures to cables
Which tickled the sailors by treating retailers as though they were all veg-e-tables
Add To Favorites View next topic View previous topic
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
