ca.portal.admin

Re: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

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


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