Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006

    Unanswered: Converting comp to ASCII IN SQL

    I am importing data from mainframe using DTS the problem is that I am getting some COMP fields from the mainframe these are compressed data fields that are used to reduce storage space on the main frame. Can some one please help me understand how we can use DTS to solve this problem that is decompress it before transferring to table in SQL server.
    any code in scripting language to help decompress this datatype will be really appreciated.


  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    the SQL forum is for the SQL language

    moving thread to Microsoft SQL Server forum | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    The usage of the COBOL "COMP" type is actually implementation specific. See the notes on COMP at DiscInterchange or pretty much any COBOL book for a discussion of this problem.

    If you know which type of mainframe the COMP field came from, I can offer a good guess at a decoder for it, but I don't know of any way to absolutely guarantee a good conversion for you.


Posting Permissions

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