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

Fri, 6 Aug 2004 16:52:50 -0400

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C47BF7.5601B00A
Content-Type: text/plain

We are able to read/write to this table in all other programs. We have
problems only on GET on RECEIVED FILE.

Sagar

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Peter Bateman
Sent: Friday, August 06, 2004 3:38 PM
To: powerh-l@lists.sowder.com
Subject: RE: Powerhouse 8.40.D on VMS vs 8.43.C on Solaris

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(r) 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=htt
p://hotmail.com/enca&HL=Market_MSNIS_Taglines 
  Start enjoying all the benefits of MSN(r) Premium right now and get the 
first two months FREE*.

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.

------_=_NextPart_001_01C47BF7.5601B00A
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2657.73">
<TITLE>RE: Powerhouse 8.40.D on VMS vs 8.43.C on Solaris</TITLE>
</HEAD>
<BODY>

We are able to read/write to this table in all other =
programs. We have problems only on GET on RECEIVED FILE.

<P><FONT SIZE=3D2>Sagar</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: powerh-l-admin@lists.sowder.com [<A =
HREF=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@li=
sts.sowder.com</A>] On Behalf Of Peter Bateman</FONT>
<BR><FONT SIZE=3D2>Sent: Friday, August 06, 2004 3:38 PM</FONT>
<BR><FONT SIZE=3D2>To: powerh-l@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>Subject: RE: Powerhouse 8.40.D on VMS vs 8.43.C on =
Solaris</FONT>
</P>

<P><FONT SIZE=3D2>It looks like QDESIGN is having a problem reading the =
metadata.</FONT>
</P>

<P><FONT SIZE=3D2>In Qshow try to display the record layout of the =
table.</FONT>
<BR><FONT SIZE=3D2>I think the syntax is</FONT>
<BR><FONT SIZE=3D2>show record &lt;tablename&gt; in &lt;dbname&gt; =
detail</FONT>
</P>

<P><FONT SIZE=3D2>Make sure the correct OWNER is specified or NOOWNER =
is chosen.</FONT>
<BR><FONT SIZE=3D2>Regards,</FONT>
<BR><FONT SIZE=3D2>Peter Bateman</FONT>
</P>
<BR>
<BR>
<BR>

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

_______________________________________________________________=
__
 MSN(r) Calendar keeps you organized and takes the =
effort out of scheduling 
 get-togethers. 
 <A =
HREF=3D"http://join.msn.com/?pgmarket=3Den-ca&page=3Dbyoa/prem&xAPID=3D1=
994&DI=3D1034&SU=3Dhttp://hotmail.com/enca&HL=3DMarket_MSNIS_Taglines" =
TARGET=3D"_blank">http://join.msn.com/?pgmarket=3Den-ca&page=3Dbyoa/prem=
&xAPID=3D1994&DI=3D1034&SU=3Dhttp://hotmail.com/enca&HL=3DMarket_MSNIS_T=
aglines</A>

<P><FONT SIZE=3D2>&nbsp; Start enjoying all the benefits of MSN(r) =
Premium right now and get the </FONT>
<BR><FONT SIZE=3D2>first two months FREE*.</FONT>
</P>

<P><FONT SIZE=3D2>=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D</FONT>
<BR><FONT SIZE=3D2>Mailing list: powerh-l@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>Subscribe: &quot;subscribe&quot; in message body to =
powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>Unsubscribe: &quot;unsubscribe =
&lt;password&gt;&quot; in message body to =
powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://lists.sowder.com/mailman/listinfo/powerh-l" =
TARGET=3D"_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</A><=
/FONT>
<BR><FONT SIZE=3D2>This list is closed, thus to post to the list you =
must be a subscriber.</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C47BF7.5601B00A--