RE: Defining fields in logical file

[CWilt@xxxxxxxxxxxx]

Titus,

Sorry, there's no way do to what you want with DDS.  If the logical has a
different format than the physical, like yours will with the additional
field, then you have to specify every field.  If the physical changes, and
you want the new field to show in the logical, then you'd have to add it.
If you don't need the new field in the logical then you'd just need to
recompile the logical.

As someone else mentioned, SQL provides a way to do this.  But you already
mentioned that you don't want to use it.  (create view myview
substr(myfield,1,2), A.* from myfile A)  Note that views can't be keyed.

HTH,
Charles

> -----Original Message-----
> From: Titus Kruse [mailto:t_kruse@xxxxxxxxx]
> Sent: Friday, February 20, 2004 3:18 AM
> To: Midrange RPG
> Subject: Defining fields in logical file
> 
> 
> Hi!
> 
> Sorry, I know that this is a little offtopic. But I only read 
> the RPG-list
> und dont wnat to subscribe to another only for one question. :-|
> 
> I want to create a logical file with all fields of the basic 
> physical file
> plus one additional field. The data in this field should be a 
> substring
> (function SST) of one of the fields above.
> 
> It seems to me that I have to specify all fields of the 
> physical file in the
> DDS of the logical file. I'm not very happy with it. When we 
> extend the
> physical record format, the logical file also must be extended.
> 
> Is there a way to copy all fields from the physical file to 
> the logical.
> Unfortunately keyword FORMAT(file) together with additional 
> fields is not
> allowed.
> 
> 
> Titus Kruse
> Software-Entwicklung IBM iSeries
> ESW Software Warda KG (GmbH & Co.)
> Telefon: +49.40.682893.22
> Telefax: +49.40.682893.28
> E-Mail: t_kruse@xxxxxxxxx
> Web: www.esw-kg.de
> 
> 
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) 
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>