ca.portal.admin

Area's defined to a subschema

Discussion created by ca.portal.admin on May 19, 2010
I have one schema that has many subschemas associated with it. I'm
trying to find out what areas are included in a particular subschema.
Is there a easy way to find this information besides displaying each
subschema?

Mike Barta



Confidentiality Note: This e-mail, including any attachment to it, may
contain material that is confidential, proprietary, privileged and/or
""Protected Health Information,"" within the meaning of the regulations
under the Health Insurance Portability & Accountability Act as amended.
If it is not clear that you are the intended recipient, you are hereby
notified that you have received this transmittal in error, and any
review, dissemination, distribution or copying of this e-mail, including
any attachment to it, is strictly prohibited. If you have received this
e-mail in error, please immediately return it to the sender and delete
it from your system. Thank you.
"
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: Area's defined to a subschema
"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 = '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 = S-NAM-010 SS-NAM-026 SSR-NAM-032
SR-ID-032

Dick

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

Outcomes