ca.portal.admin

Re: db diagram drawing tools

Discussion created by ca.portal.admin on Dec 13, 2007
Hi Vanhala

The easiest method for creating a database diagram that is a subset of a
Schema is to use the option to produce a diagram based on a Subschema.

You can specify a subschema in the IDMSRPTS job to extract a portion of
the schema. Normally, the control commands to produce a full schema
report are:

//SYSIPT DD *
SCHEMA=myschema
RECDES SETDES
/*

You can also request a subschema report containing only a portion of the
schema:

//SYSIPT DD *
SCHEMA=myschema
SUBSCHEMA=mysubschema
SUBREC SUBSET
/*

If no subschema exists that contains exactly the records, sets, and
areas that you want, you can create a temporary subschema and delete it
after you successfully create your report.

Hope this helps!

Gordon Fits-Simons

Vanhala Antti wrote:
Hello,

I'm using Schema Plus to draw database diagrams. Nice to use if you
don't have very many sets and records in the area but not so nice when
areas became larger (there is of course a possibility that I can't use
it well, tips are welcome :-). Are there any handy alternatives for this
program, would be nice if you could just select an area from the schema
report and program would then select all the records and so on and then
created a proposition for the diagram automatic.

Thanks in advance,
Antti Vanhala
WM-data - a LogicaCMG company
eFennia
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: causergroups Follow-up -stats
"So Canada as an ENTIRE COUNTRY competes against individual STATES? That
hardly seems fair . . .

Can you tell it's Friday afternoon and I'm doing my best not to open up
any new cans of worms before 5PM arrives . . . ?!

Outcomes