Re: Data transfer

["Scott Klement" <infosys@xxxxxxxxxxxx>]

Sherry...

     Perhaps I don't fully undetstand the situation, but, is there
any reason why you couldn't just download these files using something
like PC support or perhaps IDEAcomm's midrange client?

(I know you can't use client access on a system that old)

I know that with the IDEAcomm software, you can do S/36 files, because
you can define a "view" of the file, telling the system which fields
are in which places...

You can then download them into a CSV formatted file (it might be
called something else, like "variable length records" or something,
depending on the software) which could be imported directly into
Excel.

I can't think of any way to do this using the tape drive.  I guess
if you've got compatible drives on both the PC and the AS/400 you
COULD transfer it that way, but it'd almost DEFINITELY mean writing
custom software on the PC to interpret the files.  Using File Transfer
would be a *LOT* easier.

Hope that helps...

Scott Klement
Information Systems Manager
Klement's Sausage Co, Inc.


"Sherry McMahon" <smcm@frontiernet.net> wrote:
> I am involved with a school that has been using an AS/400 (2.0.1) th
>  been
> very poorly maintained.  They are going to a software package for
>  keeping
> and maintaining their student records.  Half of the records on the
>  AS/400
> are in S/36 and the rest in 400.  They have a 1/4 inch Tape Unit 634
> 00-4110454       4.   They just what to save the data and get it
>  converted
> to a text format to put into an Access database.  Because of the age
>  of the
> AS/400 and the size of the tape drive we hear more laugher when
>  looking for
> help than any useful suggestions.  The school is in Minnesota.  Does
>  anyone
> know of a company that does this sort of thing?  I've exhausted my
>  little
> circle connections and this is the last place I can think to ask.  I
> apologize for this question not being strictly RPG related.
>
> Sherry McMahon
>
>
>
>
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>  * *
> * This is the RPG/400 Discussion Mailing List]  To submit a new
>   *
> * message, send your mail to "RPG400-L@midrange.com".  To unsubscrib
>   *
> * from this list send email to MAJORDOMO@midrange.com and specify
>   *
> * 'unsubscribe RPG400-L' in the body of your message.  Questions
>  should *
> * be directed to the list owner / operator: david@midrange.com
>   *
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>  * *
>
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *