HP3000-L Archives

February 1999, Week 4

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:
"Peter Chong Sr. Systems Analyst (MRP/ERP)" <[log in to unmask]>
Reply To:
Peter Chong Sr. Systems Analyst (MRP/ERP)
Date:
Tue, 23 Feb 1999 09:57:26 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (68 lines)
Dr. Ferenc Nagy wrote in message ...
>On Fri, 19 Feb 1999, Peter Chong Sr. Systems Analyst (MRP/ERP) wrote:
>Dear Peter,
>>
>> Next step on client side,
>> I have ODBC/32 with SCHEMA EDITOR from MINISOFT
>What is that schema editor?
A. Schema Editor is
1. kind like translation tool for image for example you have
 Double Integer in Image with COBOL format pic 9(7)v99 comp.
Image store 12.34 to 1234 and you directly link ODBC/32 to IMAGE
MS Access and Excel shows 1234 instead of 12.34
Schema Editor convert 1234 to 12.34

2. It reads flat file MPE or SD format (IMAGE save, old HP list0
and COGNOS quiz subfiles in HP3000 to client PC directly via
TCP/IP connection.
Avoiding up and download process between HP3000 and Windows
95,98, NT.

>Is it able to generate MS Access table definitions form TurboImage
>database schema files?

A. Yes Link Table with ODBC User DSN or Machine DSN.

>Do you know about a tool which helps to plan MS Access tables outside of
>MS Access?

A. Any Office 97 product with MS query, I tried Excel with external data
source

Suppose you have a small DOS machine without MS Access and
>Windows NT at home, and you have some free hours on Saturday afternoon.
>You type in the table definitions in a flat file, like the TurboImage
>schema file. On Monday you translate the flat file into a MSA table
>definition, like DBSCHEMA did it for TurboImage.

A. I rather create IMAGE source schema from any text editor and upload to
HP3000
and run DBSCHEMA
>
>Do you know a TurboIMage -> MS Access 7.0 database schema converter?
>

A. Ok, Schema editor or ODBC/32 will translate IMAGE to ODBC compatable
Data source to PC via TCP/IP link, I just use Access97 v.8 to link ODBC
table
(HP 3000/IMAGE)
>
>
more info refer www.minisoft.com

May be some information is debatable, I just try best to help,
I think best tool for HP3000 since MPE II (77)
>                                                       Frank
>
>  |\    /~ ~~|~~~ Family : NAGY; first name : FERENC; title : Ph. D.
>  | \   |    |    Institute of Isotope and Surface Chemistry
>  |  \  |   -+-   H-1121 BUDAPEST Konkoly-Thege M. ut 29, (1525 Bp. POB 77)
>  |   \ |    |    [log in to unmask]  (36-1)-395-9123 Fax: ~395-9002
>  |    \|    |    http://alpha0.iki.kfki.hu/~nagyf/
>`-'     '  `-'    Home: H-1102 BUDAPEST Holgy u. 48. I. 8. (36-1)-262-1198.
>You need three virtues in the life:
>1. strength - to change the things which are changeable,
>2. patience - to endure the things which are unchangeable,
>3. wisdom   - to distinguish the above two kinds of things.
>

ATOM RSS1 RSS2