Oracle in Qshow

[Robert J.M. Edis]

G'day Ray

I don't think Qshow is capable of doing what you want.  Do you have SQL*Plus
available to you?  If so do SELECT table_name FROM all_tab_columns WHERE
column_name LIKE 'put you column name here, in caps';

In Qshow, all you can do is 'SHO REC IN databasename', sent the output to a
disc file, and scan the file with a search utility.

Regards,

Blue

-----Original Message-----
From: Ray Bailey
To: Cognos (E-mail)
Sent: 4/19/00 4:33 AM
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.