RE: Re[2]: Physical File Data in a Text

[bmegenity@xxxxxxxxxx]

Eric,
     Admitting my ignorance in front of God and everybody, would you mind   
showing me a short example of the physical file DDS with packed decimal   
and then the LF DDS with those fields redefined as zoned decimal?
     I guess I should be admitting my laziness as well, but I would   
appreciate the help.

Bill Megenity

 ----------
From:  ericadelong@pmsc.com
Sent:  Monday, June 01, 1998 12:37 PM
To:  MIDRANGE-L@midrange.com
Subject:  Re[2]: Physical File Data in a Text file !!!

 --------------------------------------------------------------------------  
 --

Converting packed numeric fields is a breeze if you create LF DDS and
redefine
the packed fields to zoned (dtatype 'S'). OS400 will convert the packed
fields
dynamically as it reads the PF. I haven't tried it, but I would think   
that
this
will work for FTP as well as it does for CA file transfer.

Eric A DeLong
ericadelong@pmsc.com

______________________________ Reply Separator
_________________________________

If the physical file does not have packed numeric fields you can use FTP
directly. It can convert the EBCDIC data to ASCII. Also, sometimes it is
easy to write an RPG or Cobol program to do the unpacking and formatting
for you. If you are interested in a commercial product we've just
released an application that can convert a file to Excel CSV or fixed
ASCII format. After the conversion you can use FTP to send to a user's
PC. You can see more about this at:
       

    http://www.patownsend.com
       

Hope this helps!
Patrick
       

       

GReddy5357@aol.com wrote:
>
> Hi,
>
> I would like to select some records from a physical file into a text   
file &
> then FTP to my hard drive. How do i go for it !!!
>
> Appreciate for any kind of suggestions.
>
> Thanks-G.
> +---
> | 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
> +---
       

 --
       

Patrick Townsend                       mailto:townsend@patownsend.com
Patrick Townsend & Associates, Inc.    http://www.patownsend.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
+---
       



+---
| 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
+---