>Jim Phillips wrote:

>On Tue, 19 Aug 1997 14:24:58 PDT, Zuheir Sayyed Ahmed <[log in to unmask]>
>(actually Salem Maharik) writes:
>
>>I am working as a computer technician in Polytechnic Institute in the ci=
>ty
>>of Hebron , Palestine. I have KSAM files stored on HP3000-42 main frame
>>computer working with MPE V operating system, How can I transfer these
>data
>>files to my PC in order to be used with  my application program

>2) Write a program on the HP in your favorite computer language to create=
>a sequential (flat) file of the KSAM data which you then download to the =
>PC and import into MS Access.  I do this all the time.  MS Access can =
>import fixed length ASCII records into existing tables with no trouble.

Since you are on MPE-V and the files are therefore classic mode KSAM, you
have a couple of simple alternatives.

You can use Fcopy to copy the data to a flat file.  This will create a file
listed in order of the primary key and may consequently be quite
time-consuming, since Fcopy reads the key file and then accesses the data
file by key.

To speed things up, use Fcopy with the parameter "NOKSAM".  The KSAM data
file is a flat file anyway, and this option ignores the keyfile and reads
it sequentially, so it is a LOT  faster.  The data will be in chronological
order.  Set Fcopy to ignore deleted records (high-values in the first two
bytes).  Be warned that the KSAM eof marker does not necessarily correspond
to the MPE eof marker, so the last few records may be garbage (very easily
recognised).  The MPE eof is at the end of the block in which the file
ends.  I would assume that you know a good deal of this, since you must use
Fcopy to remove deleted records once in a while (unless you have Copyrite).

You will also need a terminal emulator to perform the download.  I would
recommend using Reflection which can be guaranteed to work and which knows
all about converting files from the HP3000 to the PC and vice-versa.  I've
never tried it, but I imagine that Reflection would copy the KSAM file
directly just like Fcopy with the "KSAM" option.  If you have a serial
connection, you probably don't care about the access speed as your
bottleneck will be your communication circuit.  If money is a problem, try
the Minisoft emulator which is a whole lot cheaper, but, in this case,  you
get what you pay for!

John D. Alleyn-Day
Alleyn-Day International
408-286-6421   408-286-6474 (Fax)
[log in to unmask]       http://www.Alleyn-Day.com
"You have to be in the right place at the right time
but unfortunately I was absent the day they
explained how that's done" - Herb Caen.