Re: Another ftp-type question.

[Jim Essinger <dilbernator@xxxxxxxxx>]

Good point on dates Jerry.  You could create numeric versions of the
dates, and use SQL to populate the file, translating the date data
type to number.

Jim

On Wed, Feb 4, 2009 at 10:10 AM, Jerry Adams <Jerry@xxxxxxxxxxxxxxx> wrote:
> The logical does not actually contain data; it's just an index.  I doubt (though never tried it) one could actually ftp a logical; what would it point to when it got there?
>
> Others may know of a way to "trick" the LF into "unpacking" data elements into zoned data elements, but all of my LF's have the same field definitions as the PF fields.
>
> You can define a "shadow" version of the PF which contains only zoned decimal fields and use CPYF with *MAP *DROP format options to copy the original to the shadow.  This will not, however, take care of the Date data types that Sharon mentioned.  Unless the dates are not important; in which case just don't put them in the shadow.
>
> Jerry C. Adams
> IBM System i Programmer/Analyst
> B&W Wholesale
> office: 615-995-7024
> email:  jerry@xxxxxxxxxxxxxxx
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of McKown, John
> Sent: Wednesday, February 04, 2009 10:51 AM
> To: Midrange Systems Technical Discussion
> Subject: Another ftp-type question.
>
> This is just curiousity on my part. From previous responses, I know that
> I can ftp a physical file (equivalent to a DB2 table on other systems).
> If I need the information in the PF, but reformatted in some way (such
> as packed decimal as zoned or binary interger as zoned), can I just
> create an LF and then ftp the LF? If so, I would hope this would give me
> the data in the PF, but "reformated" and "selected" as specified in the
> LF. True? Thanks.
>
> John McKown
>
> Systems Engineer IV
>
> IT
>
>
>
> Administrative Services Group
>
>
>
> HealthMarkets(r)
>
> Administrative Services Group
>
> 9151 Boulevard 26 * N. Richland Hills * TX 76010
>
> (817) 255-3225 phone * (817)-961-6183 cell
>
> john.mckown@xxxxxxxxxxxxxxxxx * www.HealthMarkets.com
>
>
>
> Confidentiality Notice: This e-mail message, including any attachments,
> is for the sole use of the intended recipient(s) and may contain
> confidential or proprietary information. Any unauthorized review, use,
> disclosure or distribution is prohibited. If you are not the intended
> recipient, please contact the sender by reply e-mail and destroy all
> copies of the original message.
>
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.