MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » June 2011

Re: Program Described File and SQL



fixed

Create a DDS or DDL defined table with the appropriate fields, and CPYF from the program described file to the externally described file. You will need to specify *NOCHK on the copy command so that it doesn't try to map fields. I believe you can use an externally described file in a program that itself describes the file. I am pretty sure I have done that in the past when converting from S36 to AS400. That was a long time ago, and the memory is fuzzy. I don't thing that programs that do specify program defined files check the record format level on those files.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx

-----midrange-l-bounces@xxxxxxxxxxxx wrote: -----
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
From: Mike Wills
Sent by: midrange-l-bounces@xxxxxxxxxxxx
Date: 06/16/2011 11:03AM
Subject: Re: Program Described File and SQL

How is that done? Can it be done without affecting the existing
programs? That is something I have never had to do before.

--

Mike Wills
http://mikewills.me


On Wed, Jun 15, 2011 at 4:13 PM, Mark Murphy/STAR BASE Consulting Inc.
<mmurphy@xxxxxxxxxxxxxxx> wrote:
Convert it to an externally described file.





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact