Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009
    Posts
    24

    Unanswered: Handling packed fields

    Hi Guys, We just got a new client, during the file layout, and field mapping portion of the project we noticed that one of the fields is Comp-3 (packed).

    Does anyone know how to handle a packed field in SQL Server? Can it be done without he aide of 3rd party software?

    I tried Googling the topic but didn't get a lot of help.

    Any feedback would be helpful.

  2. #2
    Join Date
    Mar 2009
    Posts
    349
    are you doing a migration? from what to what? what is Comp-3 and where is it coming from?

  3. #3
    Join Date
    Mar 2009
    Posts
    24
    Yes we are doing a migration. Both fields are packed amount fields.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The problem is that COMP-3 is a COBOL storage method, and by definition the storage format is "system defined for optimum performance" so the translation can be different for every hardware platform and possibly even for different COBOL compilers on a single platform.

    It is highly probable that the format is some variation of Zoned Decimal for data coming from an IBM (or related such as Burroughs/Unisys) mainframe or BINARY for most other platforms.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •