CA IDMS IUA EIUA

Expand all | Collapse all

JREPORT=3D8 with Record Type and DBKEY Selection

  • 1.  JREPORT=3D8 with Record Type and DBKEY Selection

    Posted 08-05-2010 12:17 PM
    I need to run JREPORT=3D8 with BFOR and AFTER image record selection and a
    specific DBKEY selection. The syntax I am using below is not correct
    for the DBKEY selection, but I have not been able to determine the
    correct syntax. The syntax is accepted by the CULPRIT report, but I am
    fairly certain it is not correct.

    The JREPORTS section in the CA-IDMS/DB Journal Reports manual shows an
    example using field name DBKEY-A, but this field does not exist.

    Please, email me the correct syntax if you have it available.

    JREPORT=3D8
    SELECT ( TYPE EQ 'BFOR' OR TYPE EQ 'AFTR' )
    * AND ( DB-KEY EQ 16007102 )

    Thank you,

    John Collins
    SAIC

    858-826-3463 =20
    "
    IDMS 3rd-party providers forum
    IDMSVENDOR-L@LISTSERV.IUASSN.COM
    SMTP
    IDMSVENDOR-L@LISTSERV.IUASSN.COM
    IDMSVENDOR-L@LISTSERV.IUASSN.COM
    SMTP








    Normal

    Normal
    Re: JREPORT=8 with Record Type and DBKEY Selection
    "This is what we use. I do recall we call difficulty with the position of the dbkey in the journals.

    SELECT WHEN TYPE EQ ( 'BFOR' 'AFTR') AND DBKEY-FOUR/NAME EQ
    * (X'A92C630A' X'A9357C03' X'A9358F13' X'A92C630B' X'A92F6534')

    Richard Alice

    APL Ltd.


  • 2.  RE: JREPORT=3D8 with Record Type and DBKEY Selection

    Posted 08-05-2010 12:27 PM
    This is what we use. I do recall we call difficulty with the position of th=
    e dbkey in the journals.

    SELECT WHEN TYPE EQ ( 'BFOR' 'AFTR') AND DBKEY-FOUR/NAME EQ
    * (X'A92C630A' X'A9357C03' X'A9358F13' X'A92C630B' X'A92F6534')

    Richard Alice=09
    APL Ltd.


  • 3.  Re: JREPORT=3D8 with Record Type and DBKEY Selection

    Posted 08-05-2010 01:31 PM
    Hi John,

    Whenever I select by DBKEY I use DB-KEY-A EQ X'hexdbkey' where hexdbkey
    is the 4 byte hex DBKEY value.

    Hope this helps

    Pete=20