Skip to main content

[archive] Viewing data in cobol files

  • September 28, 2006
  • 4 replies
  • 0 views
D

[Migrated content. Thread originally posted on 27 September 2006]

When using a database and coding in other languages it was very simple to validate and check data by entering simple SQL queries to see how the data has changed.

Is there a simple utility for cobol files (provided I have the File Descriptions and/or XFD's) to view cobol data quickly and easily? I know there is alfred and it works pretty good but you can only see one record at a time and it is cumbersome to page through the records...

I just want to display all records and all data on the screen and be able to page up and down through the list quickly to verify my changes worked properly against the data.

Thanks for any ideas

    4 replies

    D

    [Migrated content. Thread originally posted on 27 September 2006]

    When using a database and coding in other languages it was very simple to validate and check data by entering simple SQL queries to see how the data has changed.

    Is there a simple utility for cobol files (provided I have the File Descriptions and/or XFD's) to view cobol data quickly and easily? I know there is alfred and it works pretty good but you can only see one record at a time and it is cumbersome to page through the records...

    I just want to display all records and all data on the screen and be able to page up and down through the list quickly to verify my changes worked properly against the data.

    Thanks for any ideas
    Have you thought of AcuODBC? You can link your Vision files into an MSAccess database and view the linked tables as you want.
    D

    [Migrated content. Thread originally posted on 27 September 2006]

    When using a database and coding in other languages it was very simple to validate and check data by entering simple SQL queries to see how the data has changed.

    Is there a simple utility for cobol files (provided I have the File Descriptions and/or XFD's) to view cobol data quickly and easily? I know there is alfred and it works pretty good but you can only see one record at a time and it is cumbersome to page through the records...

    I just want to display all records and all data on the screen and be able to page up and down through the list quickly to verify my changes worked properly against the data.

    Thanks for any ideas
    Have you thought of AcuODBC? You can link your Vision files into an MSAccess database and view the linked tables as you want.


    Currently we don't have AcuODBC, I think AcuCorp Charges for a license of which we don't really need at this time...

    Maybe someone has written something that mgiht be useful, I'm thinking of doing it myself If I could get the time...
    D

    [Migrated content. Thread originally posted on 27 September 2006]

    When using a database and coding in other languages it was very simple to validate and check data by entering simple SQL queries to see how the data has changed.

    Is there a simple utility for cobol files (provided I have the File Descriptions and/or XFD's) to view cobol data quickly and easily? I know there is alfred and it works pretty good but you can only see one record at a time and it is cumbersome to page through the records...

    I just want to display all records and all data on the screen and be able to page up and down through the list quickly to verify my changes worked properly against the data.

    Thanks for any ideas
    You could consider reading the xfd file in a cobol program and using the info to pull specific fields that you wish to look for.

    Brad
    D

    [Migrated content. Thread originally posted on 27 September 2006]

    When using a database and coding in other languages it was very simple to validate and check data by entering simple SQL queries to see how the data has changed.

    Is there a simple utility for cobol files (provided I have the File Descriptions and/or XFD's) to view cobol data quickly and easily? I know there is alfred and it works pretty good but you can only see one record at a time and it is cumbersome to page through the records...

    I just want to display all records and all data on the screen and be able to page up and down through the list quickly to verify my changes worked properly against the data.

    Thanks for any ideas
    I have written a crude Perl script which reads and parses the XFD, then does a 'vutil -extract' and formats the output as CSV according to the XFD fields.

    I had to rename it from 'vlist' to 'vlist.txt' to attach it to this message.

    Let me know if you need more info on this.

    Cheers.
    1 Attachments

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement