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.