InfoSphere Optim

InfoSphere Optim

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

Legacy Table - TM with a count in trailer record ?

  • 1.  Legacy Table - TM with a count in trailer record ?

    Posted Mon November 26, 2018 05:26 PM

    Optim LT - trailer count in TM / OPTIM Zos

    Did someone have an idea if OPTIM can update a trailer record in the Table Map with number of record in detail records ?

    Situation:

    One file extract with 3 different LT definition / record type:

    HEADER record type -  1 record

    DETAIL record type - different number of records

    TRAILER - 1 record 

    The TRAILER record include a column with COUNT of DETAIL's records.

    Today we have solved the problem in a cobol program updating the trailer record after the load.



    ------------------------------
    Leif Stagis
    ------------------------------

    #InfoSphereOptim
    #Optim


Related Content