unidata
Fry, Mark
Mark.Fry@COGNOS.com
Wed, 21 Nov 2001 08:59:44 -0000
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_01C1726A.DCEC2D50
Content-Type: text/plain;
charset="iso-8859-1"
Hi Donald,
I have used Unidata on HP9000 (long, long ago) and PowerHouse on HP9000, but
not both together. I think you'd struggle to connect PowerHouse on unix to
Unidata. Even if you could, you would also find incompatibilities between
the two - Unidata supports variable-length fields, multi-valued fields, and
variable-length records, and its native programming language (unibasic)
handles these using Dynamic Arrays. If anyone out there remembers Pick,
then this will all sound familiar. Your only option would be to use an ODBC
driver to connect, and use SQL in your code, but ODBC connections are not
supported from PowerHouse on HP9000. Your best bet would be to use Axiant
(which supports ODBC databases) and deploy a thick-client solution, with the
application running on your Axiant PC and the database on your HP9000. But
that assumes (of course) that you have Axiant, and that you were willing to
run the application from a PC, and you have the relevant Unidata ODBC
driver...
Regards,
Mark Fry
Cognos Limited
email: Mark.Fry@Cognos.com
Cognos Limited
Registered in England, number 1635598. Registered office: Westerly Point,
Market Street, Bracknell, Berkshire, RG12 1QB
-----Original Message-----
From: Donald Peterson [mailto:petersod@merced.cc.ca.us]
Sent: 20 November 2001 23:57
To: powerh-l@lists.swau.edu
Subject: unidata
Has anyone had the need to use Powerhouse on a HP 9000 using the Unidata
database?
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_01C1726A.DCEC2D50
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><SPAN class=3D887563108-21112001><FONT face=3DArial =
color=3D#0000ff size=3D2>Hi=20
Donald,</FONT></SPAN></DIV>
<DIV><SPAN class=3D887563108-21112001><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D887563108-21112001><FONT face=3DArial =
color=3D#0000ff size=3D2>I have=20
used Unidata on HP9000 (long, long ago) and PowerHouse on HP9000, =
but not=20
both together. I think you'd struggle to connect PowerHouse on =
unix to=20
Unidata. Even if you could, you would also find =
incompatibilities=20
between the two - Unidata supports variable-length fields, multi-valued =
fields,=20
and variable-length records, and its native programming language=20
(unibasic) handles these using Dynamic Arrays. If =
anyone out=20
there remembers Pick, then this will all sound familiar. Your =
only option=20
would be to use an ODBC driver to connect, and use SQL in your=20
code, but ODBC connections are not supported from PowerHouse on=20
HP9000. Your best bet would be to use Axiant (which supports =
ODBC=20
databases) and deploy a thick-client solution, with the application =
running on=20
your Axiant PC and the database on your HP9000. But that assumes =
(of=20
course) that you have Axiant, and that you were willing to run the =
application=20
from a PC, and you have the relevant Unidata ODBC =
driver...</FONT></SPAN></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV>
<DIV><SPAN class=3D887563108-21112001><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Regards,</FONT></SPAN></DIV><BR>
<P><I><FONT face=3D"Comic Sans MS" color=3D#000080>Mark Fry</FONT></I> =
<BR><FONT=20
face=3DArial color=3D#808080 size=3D2>Cognos Limited</FONT> <BR><FONT =
face=3DArial=20
size=3D2>email:<U> </U></FONT><U><FONT face=3DArial color=3D#0000ff=20
size=3D2>Mark.Fry@Cognos.com</FONT></U> </P>
<P><FONT face=3DArial size=3D2>Cognos Limited</FONT> <BR><FONT =
face=3DArial=20
size=3D2>Registered in England, number 1635598. Registered =
office: =20
Westerly Point, Market Street, Bracknell, Berkshire, RG12 =
1QB</FONT></P>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Donald Peterson=20
[mailto:petersod@merced.cc.ca.us]<BR><B>Sent:</B> 20 November 2001=20
23:57<BR><B>To:</B> powerh-l@lists.swau.edu<BR><B>Subject:</B>=20
unidata<BR><BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Has anyone had the need to use =
Powerhouse on a HP=20
9000 using the Unidata =
database?</FONT></DIV></BLOCKQUOTE></BODY></HTML>
<BR>
<P><FONT SIZE=3D2 FACE=3D"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 promptly by e-mail =
that you have done so. Thank you.</FONT></P>
------_=_NextPart_001_01C1726A.DCEC2D50--