New to coding with Powerhouse
Boyle, Joe
Joe.Boyle@cognos.com
Wed, 12 Sep 2001 04:31:10 -0400
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_01C13B65.468D8520
Content-Type: text/plain;
charset="iso-8859-1"
Hi Adam,
my understanding is that while Interbase is no longer supported, Powerhouse
8.13.D and higher running against Interbase is supported, and that all
information we have on file will be available to you as a supported
customer.
I hope that the following environment details for Powerhouse and database
access may be helpful to you.
The PH 8.23.D line ( latest on tru64 ) was built with the same versions of
both Interbase and Oracle as the PH 8.13.D line, in addition to Oracle 8i,
Sybase SQL Server 11.1.1 and Sybase Open Client 11.1.1.
Also, both PH 8.23.D and PH 8.13.D are supported with Informix c-isam
indexed files.
The PH 8.13.D line on tru64 was built with the environment below,
Digital UNIX 4.0
Informix C-ISAM 6.00UE1
InterBase V4.0M
Oracle Server 7.3.3
Sybase SQL Server 10.0.2
Sybase Open Client
DB-Library/C 10.0.3
Since it's release, 8.13.D has subsequently been tested with Oracle 8.
With respect to Tru64 5.0, the vendor has published claims of upward
compatibility.
With respect to Sybase 11 ( there is a comment which flags this as not yet
generally available ) the vendor has published claims of upward
compatibility.
If you do not have the source code for certain screens , qtp's etc then you
will not be able to migrate those objects to a later version of Powerhouse.
If you do not already have access to Interbase through your current PH
applications, then they will have to be modified/recompiled to run against
Interbase.
Perhaps you should consider using 8.13.D to get the data out of the
Interbase database and into subfiles, then move to a supported version of PH
and load the subfiles into a new supported data environment, for which you
might find there are both contracting skills and formal PowerHouse support
available.
-----Original Message-----
From: Adam Robertson [mailto:aroberts@orange.usyd.edu.au]
Sent: 12 September 2001 01:19
To: Powerhouse List (E-mail)
Subject: New to coding with Powerhouse
Hi all.
I am new to coding with powerhouse, and have been told by management that
there is not much in the way of support available. (ie, I have to work most
of it out myself)
We have Powerhouse ver 8.13d, with Interbase 4 as the database running on
Compaq Tru64 ver4.0f (on an Alpha box).
I understand that Powerhouse is no longer supported on Interbase 4.
My questions are:
1) Are there people on this list that will be able to provide me with
assistance in this enviroment?
And IF SO:
2) Does anyone know if it is possible to talk to the Interbase 4 database
with some sort of connectivity.
ie. Apparently ODBC is NOT available for Interbase 4, but is available
for Interbase 6
so maybe there is a way with JAVA or other product
(I want to populate web pages directly from the database)
3) We are looking to move to a newer database (ie a later version of
Interbase or Sybase) but apparently the older version of Powerhouse will not
operate with the newer database.
One alternative would be to move to a later version of Powerhouse as well,
but I assume that there would be major changes required to the source code
to do this.( It is possible that not all the source code is available).
Any Comments on this.
Thanks
Adam Robertson
Computer Systems Officer
University of Sydney, Orange (New South Wales, AUSTRALIA)
Phone: 02 6360 5967 Fax: 02 6360 5590
mailto:aroberts@orange.usyd.edu.au <mailto:aroberts@orange.usyd.edu.au>
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 by
e-mail promptly that you have done so. Thank You.
------_=_NextPart_001_01C13B65.468D8520
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>
<BODY>
<DIV>
<DIV><FONT color=#0000ff face=Arial size=2>Hi Adam,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2><FONT color=#0000ff><FONT face=Arial><SPAN
class=968483807-12092001>my understanding is<SPAN class=008480400-12092001> that
while Interbase is no longer supported, Powerhouse <SPAN
class=571253008-12092001>8.13.D and higher </SPAN>running against Interbase is
supported, and that all information we have on file will be available to you as
a supported customer.</SPAN></SPAN></FONT></FONT></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=968483807-12092001>I hope
that the following environment details for Powerhouse and database access may be
helpful to you. </SPAN></FONT><SPAN class=968483807-12092001></SPAN></DIV>
<DIV><SPAN class=968483807-12092001></SPAN><FONT color=#0000ff face=Arial
size=2> </FONT></DIV>
<DIV><FONT size=2><FONT color=#0000ff><FONT face=Arial>The PH 8.23.D line (
latest on tru64 ) was built with the same versions of both Interbase and Oracle
as the PH 8.13.D line<SPAN class=968483807-12092001>, </SPAN>in addition to
Oracle 8i, Sybase SQL Server 11.1.1 and Sybase Open Client 11.1.1<SPAN
class=968483807-12092001>.</SPAN></FONT></FONT></FONT></DIV>
<DIV><SPAN class=968483807-12092001></SPAN><FONT color=#0000ff face=Arial
size=2> </FONT></DIV>
<DIV><SPAN class=968483807-12092001></SPAN><FONT size=2><FONT
color=#0000ff><FONT face=Arial>Also, both PH 8.23.D and PH 8.13.D <SPAN
class=968483807-12092001>are supported with Informix c-isam indexed
files.</SPAN></FONT></FONT></FONT></DIV>
<DIV><SPAN class=968483807-12092001></SPAN><BR><FONT color=#0000ff face=Arial
size=2>The PH 8.13.D line on tru64 was built with the environment below,
</FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV><BR><FONT color=#0000ff face=Arial size=2>Digital UNIX 4.0</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2>Informix C-ISAM
6.00UE1</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2>InterBase V4.0M</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2>Oracle Server 7.3.3</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2>Sybase SQL Server
10.0.2</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2>Sybase Open Client </FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2>DB-Library/C 10.0.3</FONT></DIV>
<DIV> </DIV></BLOCKQUOTE>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=968483807-12092001>Since
it's release, 8.13.D has subsequently been tested with Oracle
8.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff><FONT face=Arial size=2><SPAN
class=968483807-12092001>With respect to Tru64 5.0, the vendor has published
claims of upward compatibility.</SPAN></FONT></FONT></DIV>
<DIV><FONT size=2><FONT color=#0000ff><FONT face=Arial><SPAN
class=968483807-12092001><SPAN class=968483807-12092001>With respect to Sybase
11 ( there is a comment which flags this as not yet generally available )
t</SPAN>he vendor has published claims of upward
compatibility.</SPAN></FONT></FONT></FONT></DIV>
<DIV><SPAN class=968483807-12092001></SPAN><FONT color=#0000ff face=Arial
size=2> </FONT></DIV>
<DIV><SPAN class=968483807-12092001></SPAN><FONT color=#0000ff face=Arial
size=2> </FONT></DIV>
<DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=968483807-12092001>If you
do not have the source code for certain screens , qtp's etc then you will not be
able to migrate those objects to a later version of
Powerhouse.</SPAN></FONT></DIV>
<DIV><SPAN class=968483807-12092001></SPAN><FONT color=#0000ff face=Arial
size=2> </FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=968483807-12092001>If you
do not already have access to Interbase through your current PH applications,
then they will have to be modified/recompiled to run against
Interbase.</SPAN></FONT></DIV>
<DIV><SPAN class=968483807-12092001></SPAN><FONT color=#0000ff face=Arial
size=2> </FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=968483807-12092001>Perhaps you should consider using 8.13.D to get the
data out of the Interbase database and into subfiles, then move to a supported
version of PH and load the subfiles into a new supported data environment, for
which you might find there are both contracting skills and formal PowerHouse
support available.</SPAN></FONT></DIV></DIV></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Adam Robertson
[mailto:aroberts@orange.usyd.edu.au]<BR><B>Sent:</B> 12 September 2001
01:19<BR><B>To:</B> Powerhouse List (E-mail)<BR><B>Subject:</B> New to coding
with Powerhouse<BR><BR></DIV></FONT>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>Hi all.
</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>I am new to coding
with powerhouse, and have been told by management that there is not much in
the way of support available. (ie, I have to work most of it out
myself)</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=008480400-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>We have Powerhouse
ver 8.13d, with Interbase 4 as the database running on Compaq Tru64 ver4.0f
(on an Alpha box).</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>I understand that
Powerhouse is no longer supported on Interbase 4.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=008480400-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>My questions
are:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=008480400-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>1) Are there
people on this list that will be able to provide me with assistance in this
enviroment?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=008480400-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>And IF
SO:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>2) Does anyone
know if it is possible to talk to the Interbase 4 database with some sort of
connectivity.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>
ie. Apparently ODBC is NOT available for Interbase 4, but is available for
Interbase 6</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>
so maybe there is a way with JAVA or other product</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>
(I want to populate web pages directly from the database)</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=008480400-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>3) We are looking
to move to a newer database (ie a later version of Interbase or Sybase) but
apparently the older version of Powerhouse will not operate with the newer
database.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=008480400-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>One alternative
would be to move to a later version of Powerhouse as well, but I assume that
there would be major changes required to the source code to do this.( It is
possible that not all the source code is available).</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=008480400-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=008480400-12092001>Any Comments on
this.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=008480400-12092001></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=008480400-12092001>Thanks</SPAN></FONT></DIV>
<P><FONT face=Arial size=2>Adam Robertson</FONT> <BR><FONT face=Arial
size=2>Computer Systems Officer</FONT> <BR><FONT face=Arial size=2>University
of Sydney, Orange</FONT> <FONT size=2><FONT face=Arial><SPAN
class=008480400-12092001>(New South Wales, AUSTRALIA)</SPAN><BR>Phone: 02 6360
5967 Fax: 02 6360 5590</FONT></FONT> <BR><FONT color=#000000><FONT
face=Arial size=2><A
href="mailto:aroberts@orange.usyd.edu.au">mailto:aroberts@orange.usyd.edu.au</A></FONT>
</FONT></P>
<DIV> </DIV></BLOCKQUOTE></BODY></HTML>
<P><FONT SIZE=2 FACE="Arial">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 by e-mail promptly that you have done so. Thank You.</FONT></P>
------_=_NextPart_001_01C13B65.468D8520--