Re: can I set up a multi-format logical file in DDS with one key field having a default fixed value?

[Booth Martin <booth@xxxxxxxxxxxx>]

Are the keys unique across all records?  If not, could they be?  Would 
it be a real issue?

If so, why do you care what the group is?  Why have a multi-format file? 
 What does it buy you?  Just chain for FL and get Florida and chain for 
UPS and get United Parcel Service.

On 7/26/2012 2:50 PM, Stone, Joel wrote:
> Yes I understand that LF's don't contain data.  But I would like a "read" to return data, and some of the data I would like to be fixed by its format name.
>
> I have 20 files, but lets say 2 files for discussion.
>
> STATEFL
> StateCode		stateDesc
> CA			CALIFORNIA
> FL	            FLORIDA
> TX			TEXAS
>
> CARRIERFL
> CarrierCode		CarrierDesc
> FEXED			FEDERAL EXPRESS
> UPS			UNITED PARCEL SERVICE
> USPS			US POSTAL SERVICE
>
>
>
> I would like to build a multi-format LF so that I can load the 2 keys "CARRIER" and "UPS" and return the description "UNITED PARCEL SERVICE".
>
> Using the same LF, I would also like to be able to load the keys "STATE" and "FL" and return the description "FLORIDA".
>
> Is this possible to accomplish?
>
>
> Something like:
>
> R STATEFLr                  PFILE(STATEFL)
>    GROUP                     DFT('STATE')
>    StateCode     10          COLHDG('KEY')
>    StateDesc     50          COLHDG('DESC')
> K GROUP
> K StateCode
>
> R CarrierCode		    PFILE(CARRIERFL)
>    GROUP			    DFT('CARRIER')
>    CarrierCode	          COLHDG('KEY')
>    CarrierDesc	          COLHDG('DESC')
> K GROUP
> K CarrierCode
>
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Carel Teijgeler
> Sent: Thursday, July 26, 2012 2:13 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Re: can I set up a multi-format logical file in DDS with one key field having a default fixed value?
>
> Joel,
>
> LF do not contain data, they have sequenced referrences to RRNs in the PF
> based on the key. So, what is the use to give a field in the selected lists
> of fields a value?
>
> Regards,
> Carel Teijgeler
>
> *********** REPLY SEPARATOR  ***********
>
> On 26-7-2012 at 18:43 Stone, Joel wrote:
>
> > The fixed key value would be different for each records format.
> >
> >
> > R ADMNOFFR                  PFILE(ADMNOFF)
> >   GROUP                     DFT('ADMNOFF')
> >   ADMNOFC       10          COLHDG('KEY')
> >   ADMNOFC1      50          COLHDG('DESC')
> > K ADMNOFC
> > K ADMNOFC1
> >
> >
> > This attempt returns error "Keyword 'DFT' not valid for this file type."
> >
> >
> >
> > ______________________________________________________________________
> > This outbound email has been scanned for all viruses by the MessageLabs
> > Skyscan service.
> > For more information please visit http://www.symanteccloud.com
> > ______________________________________________________________________
> > --
> > 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.
> >
> >
> >
> > -----
> > Geen virus gevonden in dit bericht.
> > Gecontroleerd door AVG - www.avg.com
> > Versie: 10.0.1382 / Virusdatabase: 2437/5156 - datum van uitgifte:
> 07/26/12