Oracle in Qshow

[Lorry Litman]

Good afternoon,

If I understand you correctly, you would like to know which tables in your
database have column name 'X'.

As far as I know the best you can get out of QSHOW is 
show records 'Y' in database
show element 'X'

Through sql you could use the database system tables to retrieve the
database table names that contain your column name.

show system tables;
 there may be a table like rdb$relation_fields
show table (column) rdb$relation_fields;
 there may be a column like rdb$field_name and rdb$relation_name
select rdb$relation_name from rdb$relation_fields
 where rdb$field_name = 'X';

Hope this helps.
Thanx
    Lorry [llitman@hsc.mb.ca]


-----Original Message-----
From: Ray Bailey [mailto:Ray.Bailey@Lightsout.co.uk]
Sent: Wednesday, April 19, 2000 3:33 AM
To: Cognos (E-mail)
Subject: Oracle in Qshow


Hi All

Hopefully this is a simple question.

I'm trying to find where an element is used within an Oracle database in
Qshow.

I need to be able to do something like SHOW ELEMENT element_name IN database

Has anybody any ideas ??  Or I'm I missing something obvious.


Thanks,

Ray Bailey
Leicester - England
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.