common hp[3|9]k dictionary

[Deskin, Bob]

Any of the PowerHouse components, QUICK, QUIZ, or QTP, can use ODBC drivers
to access data on other machines, assuming the correct ODBC driver is
available and that it has remote access capability. For example, you could
use QTP on the NT machine to access an IMAGE database on an HP3000 and a
CISAM file on an HP9000.

CISAM is not available on the HP3000. The indexed file system on HP3000 is
called KSAM. The key structure is more limited than CISAM. PowerHouse uses
KSAM for indexed subfiles on the HP3000.

Another alternative is to use portable subfiles. Generate them from the
IMAGE data on the HP3000, FTP them to the HP9000, and then use QTP to update
your CISAM files.

PowerHouse will continue to be supported on Windows NT/2000/XP. We support
ORACLE, MS SQL Server, Sybase, and DB2 (as of version 8.41) natively. As
well we support ODBC.

Bob Deskin              
PowerHouse Web 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: Victor Geere [mailto:victor@nha.co.za]
Sent: Wednesday, July 24, 2002 10:54 AM
To: Powerhouse List (E-mail)
Subject: common hp[3|9]k dictionary


Is it QUICK on NT that would link the two ODBC drivers once it becomes 
available, or would it connect to both databases natively from an NT 
machine?  Also is C-ISAM not available on the HP3K?  If not, how does
it handle indexed subfiles, something that requires C-ISAM support on 
the HP9K?  Or doesn't it?  If it does, would I be able to export Image
data to C-ISAM files on the HP3K and FTP them accross to the HP9K?

Is powerhouse going to continue being supported on NT?  
For which databases?  Natively or via ODBC?

Regards
Victor

--------------------------------------------------------------------------

Hi Victor,

The only way this can be done is if the dictionary lives on a PC and uses
ODBC access to the CISAM file and ODBC access to the Image database.
PowerHouse NT has been out for a couple of years.  The only thing that has
not been there is QUICK on NT, but it is currently in beta and will be
released by the end of summer.

Regards,

Christina Hasse
ADT North American Technical Manager
COGNOS CORPORATION
christina.hasse@cognos.com
425 N. Martingale Road, Suite 600
Schaumburg, IL  60173
Office:  847 - 285 - 2905
Cell:  847 - 612 - 6854


-----Original Message-----
From: Victor Geere [mailto:victor@nha.co.za]
Sent: Tuesday, July 23, 2002 11:01 AM
To: Powerhouse List (E-mail)
Subject: common hp[3|9]k dictionary


Is it possible to connect to C-ISAM data on a hp9k and to Image data on a
hp3k
with the same dictionary (to move data between the two without using
subfiles
or any other intermediate format)?

	1.If the dictionary is on the 9k?
	2.If the dictionary is on the 3k?
	3.If Image and the C-ISAM data is on the 3k?

Regards
Victor


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.