Re: Creating dynamic fields in a Physical file

[Raul A Jager <raul@xxxxxxxxxx>]

Repeting a group of fields for similar data representing different stores
will violate the rules for the "first normal form" in database design.
Unless there is a very strong reason for doing something different, it will
be better to respect the design rules and create a related table.
____________________________________________________________
Jim Langston wrote:

> Why not just add fields to the create table in a for loop?  Add as many as
> you want, probably want to use a varying string.
>
> Jim
>
> -----Original Message-----
> From: qppaul@mmm.com [mailto:qppaul@mmm.com]
> Sent: Thursday, May 09, 2002 1:12 AM
> To: rpg400-l@midrange.com
> Subject: Creating dynamic fields in a Physical file
>
> --
> Is it possible to create a physical file with n number of fields
> dynamically.
>
> No of fields will be determined by SQLRPGLE program.
>