Powerhouse using Oracle

[Jones Allen (Van)]

You can also add "subdict=search"  and "owner=schema_name" to the symbols
you use to run Powerhouse.  This allows you to code "file" and "access"
statements in your programs without naming the database.  Powerhouse will
search the database schema for the tables.  This may be convenient when
porting  applications.  The down side is that the file names are not fully
qualified with the database name, which may cause problems later if you have
identically named tables in different databases in the same Powerhouse
dictionary.  The best thing to do is try it different ways, learn the
differences and see what works best for you.

Good luck
Allen Jones

> -----Original Message-----
> From:	Kogan, Arthur [mailto:akogan@westpac.com.au]
> Sent:	March 11, 1999 3:35 PM
> To:	Cindy Lomas; powerh-l@lists.swau.edu
> Subject:	RE: Powerhouse using Oracle
> 
> Cindy,
> 
> all you need is a single statement defining your database in the
> dictionary. The database dictionary than becomes a subdictionary of your
> PH dictionary with every definition available to Powerhouse.
> 
> I could be wrong here, but I thought the PH8.10 does allow connection to
> Oracle on VMS (although you would loose access to some  VMS specific
> features available in PH7.10).
> 
> Regards,
> 
> Arthur Kogan
> Westpac Financial Services
> Sydney, Australia
> 
> 	-----Original Message-----
> 	From:	Cindy Lomas [SMTP:clomas@milk.org]
> 	Sent:	Friday, 12 March 1999 3: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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.