Datacom

 View Only

CA Tech Tip: CA Datacom/DB 14.0/15.0 - READRXX - New fields available.

  • 1.  CA Tech Tip: CA Datacom/DB 14.0/15.0 - READRXX - New fields available.

    Posted Mar 08, 2016 05:50 PM

    Tech Tip from JD Paquet, Principal Support Engineer, for Tuesday March 8, 2016

     

    How to get the record length when reading the RXX via READRXX?

     

    The current DBA manual (14.0 or 15.0) has the following for the layout definition of the data read using READRXX.

    ....
    10 RXX-LOGGED-TIMESTAMP.
    15 RXX-CCYYMMDD PIC X(8).
    15 RXX-HHMMSS PIC X(6).
    10 RXX-MUFPLEX-NUMBER PIC 9(3) COMP.
    10 RXX-SECURITY-USER-ID PIC X(8).
    10 FILLER PIC X(336).

     

    With solution  DB 14.0 APAR #: RO88400   two new  fields are now available: RXX-ROW-LENGTH and RXX-CLOCK-VALUE-SEQUENCE.

    Note that three other fields, displayed below, are coming with RO51924.

     

    The FILLER is now replaced with:

    ....
    10 RXX-RECOVERY-FILE_SEQUENCE PIC 9(5) COMP.    Field coming with RO51924
    10 RXX-RECOVERY-FILE_CYCLE PIC 9(5) COMP.             Field coming with RO51924
    10 RXX-MUFPLEX-NAME PIC X(8).                                         Field coming with RO51924

    *
    10 RXX-ROW-LENGTH PIC 9(3) COMP.                                << Field coming with RO88400.
    10 RXX-CLOCK-VALUE-SEQUENCE PIC X(10).                 << Field coming with RO88400.
    10 FILLER PIC X(308).

     

    An update of the manual has been requested.
    See current "COBOL Data Descriptor for RXX Read Subroutine" in the CA Datacom/DB 14.0 System and Administration Guide:

    https://support.ca.com/cadocs/7/CA%20Datacom%20DB%2014%200-ENU/Bookshelf_Files/HTML/DatacomDB14--Database_and_System_Admin_ENU/index.htm