powerhouse migration to unix and oracle

[Darren Reely]

You can have multiple database descriptions in you PDL file such as;

Database ACCOUNT1                         &
 Type ORACLE                              &
 Null Values Allowed                      &
 Open "ORACLE@ACCOUNT1@ACCOUNT1/PASSWORD" &
 Owner POWERUSER

Database ACCOUNT2                    &
  Type ORACLE                              &
  Null values allowed                         &
  Open ORACLE@OPS$USER      &
  Owner ACCOUNT2_OWNER

Database ACCOUNT3                    &
  Type ORACLE                              &
  Null values allowed                         &
  Open ORACLE@OPS$USER      &
  Owner ACCOUNT3_OWNER


Then you can refer to tables by the Powerhouse database name as in;

file ACCOUNT1.tableA alias tableA_1
file ACCOUNT2.tableA alias tableA_2 &
    access via key1 using key1 of tableA_1
file ACCOUNT3.tableA alias tableA_3

The tables can be identical structures since they are in different 
databases. Your setup can access a database on a remote system. The 
declarations I've added reference machine local databases and uses the 
current login name as the connection name user. Oracle can allow users 
to login without supplying a username/password combination. You don't 
want to open that feature to remote systems because tools like Access 
can connect and alter data.

Darren


asmah wrote:

>Hi everybody,
>
>I am in the middle of migrating from HP3000 to Sun Solaris and Oracle as the
>database used. I am new to unix and oracle.  Database declaration in PDL is
>as follows:
>
>Database ACCOUNT1 &
>
>Type ORACLE &
>
>Null Values Allowed &
>
>Open "ORACLE@ACCOUNT1@ACCOUNT1/PASSWORD" &
>
>Owner POWERUSER
>
>Let say I have several of this type database called ACCOUNT2, ACCOUNT3.
>
>I have an accounting system written in powerhouse. It seems that I need to
>compile the programs for every PDL. Is there anyway to overcome this
>problems?
>
>
>
>/---------------------------------------------------------------------------\
>
>Confidential and/ or privileged information may be contained in this
>e-mail and any attachments transmitted with it ('Message'). If you are
>not the addressee indicated in this Message (or responsible for 
>delivery of this Message to such person),you are hereby notified that
>any dissemination, distribution, printing or copying of this Message or
>any part thereof is prohibited. Please delete this Message if received 
>in  error and advise the sender by return e-mail. Opinions, conclusions
>and other information in this Message that do not relate to the 
>official business of this company shall be understood as neither given
>nor endorsed by this company.
>
>This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) 
>*Scanner Engine powered by Norman Virus Control
>
>\--------------------------------------------------------------------------/
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.swau.edu
>Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
>Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request@lists.swau.edu
>http://lists.swau.edu/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>  
>