Powerhouse 8.40.D on VMS vs 8.43.C on Solaris

[Peter Bateman]

It looks like QDESIGN is having a problem reading the metadata.

In Qshow try to display the record layout of the table.
I think the syntax is
show record <tablename> in <dbname> detail

Make sure the correct OWNER is specified or NOOWNER is chosen.
Regards,
Peter Bateman




>From: "Goparaju, Vidyasagar" <VGoparaju@tradepointsystems.com>
>To: "'powerh-l@lists.sowder.com'" <powerh-l@lists.sowder.com>
>Subject: Powerhouse 8.40.D on VMS vs 8.43.C on Solaris
>Date: Fri, 6 Aug 2004 15:33:07 -0400
>
>
>
>Hi All,
>
>We have successfully migrated our Powerhouse application from VMS/RMS to
>Oracle-9i environment on Sun/Solaris under Powerhouse version 8.43.C.
>
>Now we are in the process of migrating the same application to Powerhouse
>application on VMS/Alpha and Oracle database running on Sun/Solaris.
>Powerhouse version is 8.40.D.
>
>We are having problems on VMS/Powerhouse 8.40.D with the same source that 
>is
>running OK on Solaris accessing the same Oracle-9i database.
>
>We have GET on RECEIVED DESIGNER record structures all over our code. This
>works fine on VMS/RMS and Oracle-9i on Solaris under Ph-8.43.C.
>
>Under Ph 8.40.D environment, QDESIGN issues a WARNING "ACCESS ignored on
>received file" and I am getting the following runtime error on QUICK
>"No relation has been specified on file....".
>
>Code change is not a good solution as we have exceeded 31 file limits on
>most of these programs and also we have too many programs to change.
>
>I am working with Cognos Support.
>
>Please let me know if you have any suggestions.
>
>Thanks very much,
>Sagar
>
>

_________________________________________________________________
MSNŽ Calendar keeps you organized and takes the effort out of scheduling 
get-togethers. 
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines 
  Start enjoying all the benefits of MSNŽ Premium right now and get the 
first two months FREE*.