ca.portal.admin

Re: Area's defined to a subschema

Discussion created by ca.portal.admin on May 23, 2010
Here's a Culprit solution to locate which Subschemas have a particular
AREA - this can also be useful - just change Schema and Area combination
on DEFAULT line - HTH - cheers - Gary=20

DEFAULT &&1=3DSCHEMA=3D'SCHMJIS',&&2=3DAREA=3D'OF-OFOFFC01' =20
IN 1000 DB(D) SS=3DIDMSNWKA,IDMSNTWK =20
PATH01 S-010 SA-018 SSA-024 SS-026 =20
KEY S-NAM-010 ( '&&1' ) =20
SEL SA-018 IN PATH 01 WHEN SA-NAM-018 =3D '&&2' =20
01OUT 79 D PS DD=3DSUBS =20
01SORT SS-NAM-026 =20
013 Subschemas FOR Schema: &&1 Area: &&2 =20
0151*020 SS-NAM-026 HH 'Subschema' =20
0151*030 DATE-CREATED-026 HH 'Date Created' =20
0151*040 TIME-CREATED-026 HH 'Time Created' =20
0151*050 ERR-026 HH 'Error?' FM 'Z' =20


Gary Cherlet
Justice Technology Services
Department of Justice, SA Government
Telephone +61 (0)8 8226 5199
Facsimile +61 (0)8 8226 5311
Mobile +61 (0)41 333 1613
MailTo:gary.cherlet@sa.gov.au

This e-mail message and any attachments are qualified as follows:
Addressing: If you have received this e-mail in error, please advise by
reply e-mail to the sender. Please also destroy the original
transmission and its contents. Confidentiality: This e-mail may contain
confidential information which also may be legally privileged. Only the
intended recipient(s) may access, use, distribute or copy this e-mail.
Individual Views: Unless otherwise indicated, the views expressed are
those of the sender, not Justice Technology Services. Computer Viruses:
It is the recipient's responsibility to check the e-mail and any
attached files for viruses.

Outcomes