ca.portal.admin

JREPORT=3D8 with Record Type and DBKEY Selection

Discussion created by ca.portal.admin on Aug 5, 2010
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
"John,

JREPORT 000 shows these fields defined for the before and after images:

*+   REC DBK-FORMAT                       45  4 1

*+   REC DBK-LINES                        48  1 1

*+   REC DB-KEY                           49  4 1

*+   REC DB-KEY1                          49  3 1    $IDMS/1209

*+   REC DB-KEY2                          52  1 1    $IDMS/1209

*+   REC DB-KEY-A                         49  4      $Hex compares
IDMS/2721


In the example portion of my JREPORT 8 JCL I have:

SELECT WHEN TYPE EQ ( 'BFOR' 'AFTR' )
* AND DB-KEY-A EQ ( X'22C6DE03' )

And

SELECT WHEN TYPE EQ ( 'BFOR' 'AFTR' )
* AND DB-KEY EQ ( 1179406117 )
* OR DB-KEY-A EQ ( X'46BEAB86' )

Hope this helps.

Dick

Richard Pierce
(617) 973-8911
richard.pierce@state.ma.us

Outcomes