Re: transfer of s36 files from as400 to excel

It's easy.  Just create a logical file with the same fields as what you'd
have if you internally described the s/36 files.  The important thing is to
define the packed fields as packed in the DDS.  Then copy the s/36 files
into the newly defined database files.

If you're using client access to transfer them, just be sure to translate
the packed fields... I think it's a check box somewhere that says
CCSID=65335 or something like that (I'm at home now... I don't remember this
precisely)  Just make sure that is checked, and everything should work fine.
Oh, for the downloaded PC file, choose comma delimited or the Excel 5
format.

Good luck!

----- Original Message -----
From: <conor.farrell@dubport.ccs.ie>
To: <MIDRANGE-L@midrange.com>
Sent: Wednesday, June 14, 2000 12:34 PM
Subject: transfer of s36 files from as400 to excel


> We have just completed a s36 to as400 migration. I cannot transfer the s36
files from the AS400 to a spreadsheet as it reads each record as one field.
>
> Has anybody managed to do this
>
> Regards
>
> Conor Farrell
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---
>

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---