Skip to main content

[archive] Comp-3 Field conversion

  • September 22, 2006
  • 1 reply
  • 0 views
D

[Migrated content. Thread originally posted on 26 August 2006]

We have some fields that are COMP-3. What we would like to do is export those to a text file and import them using a DTS packet into SQL tables. We know that AcuODBC will do this but we can't handle the data in that manner.

We have made all steps work except taking the text file with COMP fields and converting them to something that can be used. The only thing that we have been able to do it take another COBOL program and do it but that is not an option with the size of the data that we have to use daily.

If anyone has been able to take a Vision file with COMP-3 fields in the layout and convert the exported text files please let me know.

Thanks

    1 reply

    D

    [Migrated content. Thread originally posted on 26 August 2006]

    We have some fields that are COMP-3. What we would like to do is export those to a text file and import them using a DTS packet into SQL tables. We know that AcuODBC will do this but we can't handle the data in that manner.

    We have made all steps work except taking the text file with COMP fields and converting them to something that can be used. The only thing that we have been able to do it take another COBOL program and do it but that is not an option with the size of the data that we have to use daily.

    If anyone has been able to take a Vision file with COMP-3 fields in the layout and convert the exported text files please let me know.

    Thanks
    Hi,

    I guess you've tried VUTIL -UNLOAD and found that comp-3 fields don't work too well. Even in binary mode, you'll get binary output which doesn't provide any information about where the decimal place belongs (this is determined at runtime by the program examining the data and isn't stored in the data file).

    My suggestion would be a third party report writing tool, something like Cyberscience's VCQ, but not knowing your site or budget, this might be like buying a sledgehammer to open a walnut.

    Best of luck,

    Ian

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement