Powerhouse using Oracle

[Whittall, Conrad]

The PDL DATABASE statement is all that is needed to enable PowerHouse to
work with an Oracle database, so your PowerHouse data dictionary could be
very small.

PowerHouse uses the metadata of relational databases such as Oracle, Sybase,
MS SQL Server, etc., as subdictionaries -- retrieving the physical
structures of tables and indexes directly from the database metadata. You
can optionally have ELEMENT definitions in your PowerHouse data dictionary
which will then be used as "logical" overlays to the physical column
definition (of the same name) retrieved from the database. Hence you can add
user help, screen labels, report headings, picture and pattern clauses and
all of that other good PowerHouse stuff on top of whatever your relational
database provides.

Best regards,

Conrad

Conrad Whittall
Marketing Manager, Application Development Tools
Cognos Incorporated, 3755 Riverside Drive, Ottawa, Ontario, K1G 4K9, Canada

E-mail : conrad.whittall@cognos.com
Tel : + 1 (613) 738-1338 Ext.4804
Fax : + 1 (613) 228-3149


-----Original Message-----
From: Cindy Lomas [mailto:clomas@milk.org]
Sent: Thursday 11 March 1999 11:16 AM
To: powerh-l@lists.swau.edu
Subject: Powerhouse using Oracle


We are currently using Powerhouse on VMS with RMS files. We are looking
into using Oracle with PH. Will it be necessary to have a dictionary
definition of the database or is this covered by the PDL DATABASE statement
(i.e. will we doubling our DBA work?)

Thanks,
Cindy Lomas
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.