HP3000-L Archives

September 1996, 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:
Tracy Johnson <[log in to unmask]>
Reply To:
Tracy Johnson <[log in to unmask]>
Date:
Wed, 25 Sep 1996 11:36:00 PDT
Content-Type:
text/plain
Parts/Attachments:
text/plain (65 lines)
If you have Powerhouse (QUIZ) you can create an ANSI tape with the following
commands:
 
>ACCESS filename
>REPORT SUMMARY ALL
>SET REPORT DEVICE TAPE
>SET SUBFILE NAME xxxx
>GO
 
It will probably ask for a reply at the console.
 
If you have Sheetmate from Hillary Software you can access the Image
database directly and download the fields of a single dataset  to your hard
drive on your PC.  In spreadsheet format, dBase, .PRN or other file types.
 
 ----------
From: owner-hp3000-l
To: Multiple recipients of list HP3000-L
Subject: IMAGE DB to Tape
Date: Wednesday, September 25, 1996 12:57PM
 
This message was posted on the HPSYSTEMS forum of CompuServe.  I'm reposting
it
here in the hopes that someone can help.  Please reply directly to the
original
sender (Michelle Glenn - [log in to unmask]).
 
 -----------------------------FORWARDED
MESSAGE------------------------------------
 
Subj:  HP Image DB                      Section: MPE systems
  To:  Charles R. Fregeau, 74170,3206   Tuesday, September 24, 1996 5:34:25
PM
From:  Michelle Glenn, 76072,1207       #156005
 
Charles,
Thanks for taking the time to reply, I had no hope that anyone would know
anything about such an old system.  Our situation is this - we have data in
the
database on the HP that we want to extract so that we can upload it to
another
machine (Windows NT, SQL Server).  The HP is a 'stand alone' system, it is
not
networked, and does not have a modem.  Our only option to remove the data is
to
write it to tape, we do have a 9 track tape.  Adding to our problem is that
we
have no one here who is proficient on ethier the HP hardware or software.
 We
do
have a query that will run and write the data to tape; however, the output
fills
 
one tape and requires another.  At that point the job aborts.  We were
hoping
to
find some parameter to add to the job to allow for multiple tapes.
I appreciate your suggestion to STORE the data to a file; that sounds good,
but
I'm still stuck with how to get it off the HP.  We do run nightly backups on
the
system, but don't have another HP to restore to.  Any suggestions will be
appreciated.
                                               Michelle

ATOM RSS1 RSS2