ca.portal.admin

Re: Area's defined to a subschema

Discussion created by ca.portal.admin on May 20, 2010
Try this out (it's an olq qfile) it may give you more than you wish, but yo=
u can edit if you wish. (note the subschema (MMVLECOM) name in the select =
statement.

SET ACCESS OLQ
SET DICTNAME SYSDIRL
SET UNDERLINE '-'
SIGNON SS IDMSNWKA SCHEMA IDMSNTWK( 1)
OPTIONS ALL HEADER ECHO NOFILLER SPARSE WHOLE INTERRUPT OLQHEADER NOPATHS=
TAT NOSTAT NOCOMMENT VERBOSE NODBKEY PICTURE CODETAB NOSYN SELECT 'S-010'.=
'S-NAM-010' 'SS-026'.'SS-NAM-026'
'SSR-032'.'SSR-NAM-032' 'S
032'.'SR-ID-032' FROM 'OOAK-012', 'S-010', 'SS-026', 'SSR-032' WHERE ('OO=
A ' AND 'S-SS' AND 'SS-SSR') AND ((OOAK-012.OOAK-KEY-012 =3D 'OOAK') AND
(SS-02
S-NAM-026 MATCHES 'MMVLECOM'))
EDIT S-NAM-010 -
ALIGN LEFT -
OLQHEADER 'SCHEMA'-
'NAME'-
PICTURE 'X(8)'
EDIT SS-NAM-026 -
ALIGN LEFT -
OLQHEADER 'SUBSCHEMA'-
'NAME'-
PICTURE 'X(8)'
EDIT SSR-NAM-032 -
ALIGN LEFT -
OLQHEADER 'RECORD'-
'NAME'-
PICTURE 'X(32)'
EDIT SR-ID-032 -
ALIGN RIGHT -
OLQHEADER 'RECORDS'-
'SR'-
'NUMBER'-
PICTURE '-ZZZZ9'
PAGE HEADER BLANK LINES AFTER 1 -
LINE 1 'RECORDS WITHIN A SUBSCHEMA BY RECORD NAME REPORT' CENTER -
LINE 2 '$DATE' CENTER
PAGE FOOTER BLANK LINES BEFORE 1 -
LINE 1 '- $PAGE -' CENTER
SORT -
ON SSR-NAM-032
DISPLAY SPREAD EVEN COLUMNS =3D S-NAM-010 SS-NAM-026 SSR-NAM-032
SR-ID-032

Dick

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

Outcomes