Show files error

[Joe Boyle]

in fact, it could be that you need to use 'qshow subdict=search'

Regards, Joe. 

  _____  

From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Joe Boyle
Sent: 14 February 2006 20:18
To: Johnson, Harold A EDUC:EX; powerh-l at lists.sowder.com
Subject: Re: Show files error

 

try 'show file in mydbname'

----- Original Message ----- 

From: Johnson, <mailto:Harold.A.Johnson at gov.bc.ca>  Harold A EDUC:EX 

To: powerh-l at lists.sowder.com 

Sent: Tuesday, February 14, 2006 8:03 PM

Subject: Show files error

 

Hi all.  I get the following error when I try to do a "Show files" command
in quiz or qshow (for example).  Any ideas what is causing this?  I get the
same error in all of our environments for a particular system (ie: deve,
test, prod). It's been occuring for some time (months) but there doesn't
seem to be any other problems with either the database or with Powerhouse.

A QSHOW "show record" of the product_component_version" comes back fine. 
A "show table" in SQL is fine.

OpenVMS v7.3-2
Oracle RDB v7.1-241
Powerhouse v710g1

$quiz

>show file

...

... lots of tables

...

ALL_SNAPSHOTS IN SFAS_DATABASE

USER_SNAPSHOTS IN SFAS_DATABASE

PRODUCT_COMPONENT_VERSION IN SFAS_DATABASE

*E* Relational Database access failed.

%RDB-E-ARITH_EXCEPT, truncation of a numeric value at runtime

%COSI-F-INTOVF, integer overflow

 

 

 


  _____  


-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe &lt;password&gt;" in message body to
powerh-l-request at 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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060214/41d67bb6/attachment.htm