Oracle Dictionary

Boyle, Joe Joe.Boyle@cognos.com
Wed, 29 May 2002 10:59:22 +0100


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_01C206F7.81CED5E0
Content-Type: text/plain;
	charset="iso-8859-1"

Hi Victor,

first check that the correct dictionary is set with command 'showdict', if
not, set to the dictionary with command 'setdict <filespec>',  and then run
qshow and either type 'show database detail' or do the following, type 'show
database', if more than one database is listed, decide which database you
want to see and then type  'show database <databasename>'.


-----Original Message-----
From: Victor Geere [mailto:victor@nha.co.za]
Sent: 29 May 2002 10:39
To: powerh-l@lists.swau.edu
Subject: Oracle Dictionary


Can anybody show me an example of a Powerhouse dictionary for Oracle?

I am using

DATABASE OEMREP&
  TYPE ORACLE &
  OPEN ORACLE@system@oemrep/pwd &
  OWNER oracle &
  NULL VALUES ALLOWED

The owner is an OS(HP-UX) username that was used to install Oracle.

The tnsname tests successfully in the net manager.
I can also connect to it through jsp.


Is there a way to check whether Oracle support is enabled in Powerhouse, and
if not, does Powerhouse have to be reinstalled completely?
Are there any other snags as far as Powerhouse and Oracle is concerned that
I need to be aware of?

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

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.

------_=_NextPart_001_01C206F7.81CED5E0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">



RE: Oracle Dictionary



Hi Victor,

first check that the correct dictionary is set with = command 'showdict', if not, set to the dictionary with command 'setdict = <filespec>',  and then run qshow and either type 'show = database detail' or do the following, type 'show database', if more = than one database is listed, decide which database you want to see and = then type  'show database <databasename>'.


-----Original Message-----
From: Victor Geere [mailto:victor@nha.co.za]
Sent: 29 May 2002 10:39
To: powerh-l@lists.swau.edu
Subject: Oracle Dictionary


Can anybody show me an example of a Powerhouse = dictionary for Oracle?

I am using

DATABASE OEMREP&
  TYPE ORACLE &
  OPEN ORACLE@system@oemrep/pwd &
  OWNER oracle &
  NULL VALUES ALLOWED

The owner is an OS(HP-UX) username that was used to = install Oracle.

The tnsname tests successfully in the net = manager.
I can also connect to it through jsp.


Is there a way to check whether Oracle support is = enabled in Powerhouse, and if not, does Powerhouse have to be = reinstalled completely?

Are there any other snags as far as Powerhouse and = Oracle is concerned that I need to be aware of?

=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
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to = powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body = to powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you = must be a subscriber.

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.

------_=_NextPart_001_01C206F7.81CED5E0--