ca.portal.admin

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

Discussion created by ca.portal.admin on Aug 6, 2010
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 =20


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

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

And=20

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

Hope this helps.

Dick

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

Outcomes