ca.portal.admin

Re: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
you 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
NOPATHSTAT 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
('OOA ' 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