× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. July 2012

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

I did try building an LF and it appears that the key fields do NOT need to be the same length.

Although I need to add a GROUP key in front of each format's key, which appears to be the main stumbling block.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Carel Teijgeler
Sent: Thursday, July 26, 2012 3:42 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,

This might be possible, but all key fields should be the same length (can
be done in LF IIRC). Compiler may have issues then.

Then you chain with your key value to the LF

In the I-specs you have defined the different RCDFMT with an indicator
assigned to it. The indicator is turned on for the RCDFMT read based on the
CHAIN.
(based on my fading memory).

But as others has stated, you have to individualy chain for each data set.

Regards,
Carel Teijgeler


*********** REPLY SEPARATOR ***********

On 26-7-2012 at 19:50 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



--
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.


________________________________________________________________________
This inbound email has been scanned for all viruses by the MessageLabs
SkyScan
service.
________________________________________________________________________

______________________________________________________________________
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




As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.