COMP-3 Conversion RRS feed

  • Question

  • When we migrate the data from DB2, it has data from the COBOL-Program using char(08) but it stored the numeric s9(5)V99 comp-3 data.

    When using SSMA, it converts char(80 t0 Char(08).  Is there a way in T-SQL to unpack the data to ASCII  character string?


    Hon-Wai Kong

    Friday, November 20, 2015 8:59 PM