powerhouse migration to unix and oracle

[Peter Bateman]

Asmah:

   I would make sure that there is no reference to the schema
   owner in the powerhouse code. ie use the NOOWNER on compile.

noowner
Prevents the owner name from being attached to the table name
in generated code so that different users can use the same compiled screen 
to access their own tables (having the same name).


Then when I want to run the application for a particular
account I would use the the run time parmeter OWNER.

Regards,
Peter

>From: "asmah" <asmah@nadi.com.my>
>To: <powerh-l@cube.swau.edu>
>Subject: powerhouse migration to unix and oracle
>Date: Wed, 24 Sep 2003 12:47:16 +0800
>
>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.

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail