help with PH8 on HP/UX PDL

[Watt Peter (Van)]

Blue,

Here is an example of our database definition for an Oracle database:

Database VPE
&
  Type ORACLE
&
  Null values not allowed
&
  Open ORACLE@user@instance/passwd & 
  Owner vpemgr

Do not forget that you must define the Oracle instance name in the
tnsnames.ora file.  To test if you have access to the database, try:
export ORACLE_SID=<instance_name>
sqlplus user/passwd
>select * from <table_name>;

If you do not connect to the database, then the instance has not been
described properly.

There is no tool to simply dictionary definitions that I am aware of.
Just the magic of 'vi'!

Feel free to contact me directly if you need any other information.

Peter Watt


> -----Original Message-----
> From:	EDISR@detroitedison.com [SMTP:EDISR@detroitedison.com]
> Sent:	Wednesday, June 17, 1998 1:19 PM
> To:	powerh-l@lists.swau.edu
> Subject:	help with PH8 on HP/UX PDL
> 
> Help! 
>  
> We are testing PowerHouse 8 on a HP/UX machine with an Oracle 7
> database. 
> We have a 30 day 'test' license and no (virtually) documentation. 
>  
> How do we create and reference Oracle 7 database and tables? 
> What is the PDL syntax?  Is there an equivalent to PHDMAINT to
> maintain the 
> PHD?  
>  
> We have used '>file filename organization relational type oracle open 
> "user/password@instance"' and '>database filename type oracle open 
> "user/password@instance"' and variations of the above.  PDL issues no
> error 
> but when using QSHOW or QUIZ, we are told the file or database doesn't
> exist. 
>  
> Any ideas? 
>   
>  
> Robert Edis (Blue) 
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> = = =
> 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.