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

how to limit the number of rows of the compare report

  • 1.  how to limit the number of rows of the compare report

    Posted Mon December 12, 2022 09:36 AM
    I'm using optim on z/os.
    I'm running the jcl to produce a detailed compare report, but I would like to limit the number of rows to be reported.
    these are the oprions I used: 

    -- UTILITY CONTROL STATEMENTS
    ---------------------------------------------------
    --
    TRANSLATION_TECHNIQUE RE
    ALLOW_CONVERSION_ERRORS NO
    DATA_SET_PREFIX USERID
    ---------------------------------------------------
    -- COMPARE OPERATION
    -- TIME THAT JOB WAS GENERATED: 2022-12-06 16.01
    ---------------------------------------------------
    COMPARE
    UNKNOWN ALLOW
    ---------------------------------------------------
    -- KEYWORDS DEFINING THE COMPARE DEFINITION
    ---------------------------------------------------
    COMPARE_DEFINITION_DEFINE (
    CDNAME $$TEMP$$.CD.$$NAME$$
    SRC1TYP EXTR AGONFVN.PSS.TEMP.EF.MASK.AN.A0ANSTC2
    SRC2TYP EXTR AGONFVN.PSS.TEMP.MF.MASK.AN.A0ANSTC2
    TM (
    SRCCID AGOF
    DESTCID AGOF
    (ANT_STRLC_CPA = AGOF.ANT_STRLC_CPA
    MATCH_KEY_PROPERTY N
    MATCH_METHOD A
    SOFT_MATCH_ENABLED Y
    PERCENT_REQUIRED 50
    PERCENT_ACCEPTABLE 100
    MAXIMUM_ATTEMPTS 0)
    )
    ) ;
    -------------------------------------------------------------------
    -- KEYWORDS DEFINING THE COMPARE PARAMETERS
    -------------------------------------------------------------------
    COMPARE_FILE(DSNAME AGONFVN.PSS.TEMP.CO.MASK.AN.A0ANSTC2 MODE USE)
    REPORT_MODE YES
    REPORT_FILE(DSNAME AGONFVN.PSS.CF2.REPORT MODE USE)
    REPORT_TYPE DETAIL
    REPORT_LINES 57
    WRAP_LINES EXTEND
    REPORT_FORMAT SIDE_DIFF
    ROW_DISPLAY (UNUSED)
    /*

    ------------------------------
    Massimo Palleschi
    ------------------------------

    #InfoSphereOptim
    #Optim