Hi
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.
Thanksthe SQL forum is for the SQL language
moving thread to Microsoft SQL Server forum|||The usage of the COBOL "COMP" type is actually implementation specific. See the notes on COMP (http://www.discinterchange.com/TechTalk_COBOL_comp_.html) 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.
-PatP
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment