Post reply

Reading in Packed Decimal Numbers

  • September 18, 2003 at 8:02 am

    #65107

    I'm trying to read in a text file with packed decimal numbers. How can I do this?

  • September 18, 2003 at 9:37 am

    #474895

    Try this

    http://www.sqlservercentral.com/scripts/contributions/617.asp

  • September 19, 2003 at 6:45 am

    #475032

    Paul;

    Does your file also contain text (alphanumeric) data? If so, and you converted the IBM EBCDIC characters to ASCII characters during the download (almost always automatically done), then your packed decimal data will be scrambled.

    If this is the case, you have two options. Convert the packed decimal to decimal character field before the download. That way the EBCDIC conversion can convert the digits as characters.

    Or, do not perform any translation at download, and write a routine that converts the characters yourself. It's not difficult, and you can then not convert the packed decimal parts and instead decode and convert the number.



    Mark

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply