Re: Add a unique key field to view without redefining table

On Tue, 2016-12-13 at 09:18 -0700, Charles Wilt wrote:

On Tue, Dec 13, 2016 at 8:54 AM, Dan <dan27649@xxxxxxxxx> wrote:

Doable, but a maintenance
nightmare.

​Not really, no.

The idea is that the LFs will never change. And once you build the first
field list, it's a simple matter to copy and past to the other logicals.

Not near an i at the moment... but according to the DDS manual the
FORMAT keyword can be used to reference an existing file.

A R RECORD PFILE(FILEA)
A FORMAT(FILEB)

So assuming it works, have one LF defined with the selected fields then
all other LF's reference, with the FORMAT keyword, that logical.

Not sure if SQL has something similar, my guess would be a NO...
although that being said, a PC SQL interface is much less of a burden,
than green screen, due to its cut and paste abilities as is DDS via RDI.