question about databases on VMS

[Daniel.Miller@Nightfreight.co.uk]

thanks,

thats definitely something to bear in mind in the future.

Daniel Miller

-----Original Message-----
From: Deskin, Bob [mailto:Bob.Deskin@Cognos.COM]
Sent: Monday, February 28, 2005 1:41 PM
To: Miller, Daniel; powerh-l@lists.sowder.com
Subject: RE: question about databases on VMS


That's one of the big advantages of PowerHouse, its ability to access
multiple data sources at the same time. So the answer is a big yes, we
can access RMS file and relational databases from the same dictionary
and the same program. In fact we can access multiple relational
databases from different vendors at the same time. This means that
moving from one data source to another is relatively easy with
PowerHouse.

As for your other questions, each data source has its strengths and
weaknesses. I don't know that there's any particular technical reason
not to use a mix of data sources. Certainly if you're moving to
relational, you want to move as much as possible into the relational
database to make full use of its functionality. On the other hand, some
things are best left outside. For example, if you receive a file from
another company or location, you might not want it inside your
relational database.

And as for which versions of PowerHouse, PowerHouse started supporting
relational databases (RDB) on OpenVMS in 1987. On MPE/iX, PowerHouse
supported IMAGE, KSAM, and MPE files from day 1 (1979). So it has always
supported multiple data sources.

Currently on OpenVMS (8.40) PowerHouse supports RMS, Oracle and Oracle
RDB.

Bob Deskin              
Senior Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of
Daniel.Miller@Nightfreight.co.uk
Sent: February 28, 2005 8:27 AM
To: powerh-l@lists.sowder.com
Subject: question about databases on VMS


Hi,

We dont use a relational database on vms so this might be a nonsensical
question.  

Can you have rms and say classic oracle in the same dictionary / same
programs? e.g. an entry screen which writes to rms and oracle or a qtp
which picks up an rms file and writes to a relational database.

If it is possible is it inadvisable for any reason? or only possible in
certain versions of ph?

tia
Daniel Miller

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