HP3000-L Archives

November 1995, Week 5

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
John Schmid <[log in to unmask]>
Reply To:
John Schmid <[log in to unmask]>
Date:
Thu, 30 Nov 1995 12:21:05 -0600
Content-Type:
text/plain
Parts/Attachments:
text/plain (36 lines)
Thanks Denys for the survey:
 
<intro sniped>
>OK, question 1.  How many of you out there are actively using IMAGE/SQL WITH
>SQL access?  Not just to say "We have updated to IMAGE/SQL," but rather, "we
>have attached production databases and we are accessing the data in IMAGE
>through the SQL interface".  It doesn t have to be totally SQL, but a least
>some portion of it, perhaps ad-hoc reporting, should be in SQL.
 
3M now has several users of IMAGE/SQL. The most popular usage is ad hoc queries
using MS Access. We have several PowerBuilder applications that are in
development and a few in production that make queries to legacy data. We have
one manufacturing application that uses Cognos products on HP-UX while
accessing legacy data from IMAGE/SQL on MPE/iX via Allbase/NET.
 
>
>Question 2.  How many of you are actively accessing attached IMAGE/SQL data
>via ODBC or other middleware in a client/server fashion to PCs?  How are you
>doing it?  Which end-user tools (shrink-wrapped or otherwise) are you using?
> Are you developing with VB or perhaps something else?
 
We primarily use the ODBC software supplied by HP (HPPCAPI.PUB.SYS). It has
been reported that some of our users purchase ODBC from a third party
supplier, such as, Intersolv. As per above, we use MS Access plus the other
MS tools (Excel, Query, etc.) and Cognos Impromtu. Most of our development
is done with PowerBuilder.
 
<snip the rest as N/A>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> John Schmid         < My opinions > voice: 612-733-9906     <
> Lead DBA            < do not not  >   fax: 612-736-7757     <
> 3M Company          < necessarily > email: [log in to unmask] <
> 3M Center 224-3S-25 < represent   >                         <
> St. Paul, MN 55144  < those of 3M >                         <
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ATOM RSS1 RSS2