QSHOW: how to show details on an element for a specific database

[Deskin, Bob]

Elements are logical entities and aren't directly associated with anything. Rather, when you have a database column that has the same name as an element, the column takes the properties of the element for things like editing and formatting.
 
Bob

-----Original Message-----
From: powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com [mailto:powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com]On Behalf Of Joe Boyle
Sent: September 19, 2005 4:50 AM
To: fernando.olmos at hpa.com.au; powerh-l at lists.sowder.com
Subject: RE: QSHOW: how to show details on an element for a specific database



I don't think you can associate an element with a specific database, whatever is there is being use by all databases. What makes you think that the element you see is database specific ?

 

The only explanation might be that your element appears in the dictionary source code after the database statement associated with the database of interest; this might mean that the element, although present in the dictionary, isn't being used by your database - if so, you could always move the element statement.

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 fernando.olmos at hpa.com.au
Sent: 19 September 2005 02:43
To: powerh-l at lists.sowder.com
Subject: QSHOW: how to show details on an element for a specific database

 

Hi gang, 

I am trying to get detailed information about a particular column in a database, using QSHOW. 

I am trying things like ... 

show ele actual_qty of order_detail 

but I get syntax errors on the [of] verb. 

I can do ... 

show ele actual_qty 

but it brings me information for the column, from a totally different database 

I also tried ... 

show ele actual_qty IN order_detail  but again I get errors. 

 

Thank you all. 

 

Fernando Olmos 
M.I.S. 

HPA
Direct:  03 9217 5411
Mobile: 0410 382 857
Fax:     03 9217 5716 

 <file:///H:\Appdata\Microsoft\Signatures\www.hpa.com.au> www.hpa.com.au 
  
       This message may contain privileged and/or confidential information.  If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so.  Thank you. 
        
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20050919/bd8a0547/attachment.htm