MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » August 2014

RE: Cautionary Quiz



fixed

Trevor, you happened to "say the magic word".

About two years ago I created the logical file with a key that was not unique,
and even commented the reason for not declaring the key UNIQUE.

The based-on physical file did and does have a unique key.

Time passes . . . I update the app and in the course of making changes, re-visit
this file and "re-think" the "Pallet Id" key, deciding I can and should make it
unique.

We know now I was wrong, but what I did not know was i OS would
create the file, but because the data would not support the key,
would, correctly, not create a file member.

Be careful what you ask for they say.

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Briggs, Trevor (TBriggs2)
Sent: Friday, August 01, 2014 8:47 AM
To: Midrange Systems Technical Discussion
Subject: RE: Cautionary Quiz

This is an absolute WAG, but is it possible that the file has non-unique keys? This would be a problem if you added UNIQUE to the LF.

Trevor Briggs
Analyst/Programmer
Lincare, Inc.
(727) 431-1246
TBriggs2@xxxxxxxxxxx
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary Thompson
Sent: Friday, August 01, 2014 10:28 AM
To: Midrange Systems Technical Discussion
Subject: RE: Cautionary Quiz

Yes, but why did the initial compile not create a member ?

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gqcy
Sent: Friday, August 01, 2014 8:25 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Cautionary Quiz

are there any members on the file currently?
you may have compiled the object, but the member may not have been added...


On 8/1/2014 9:15 AM, Gary Thompson wrote:
V7R1M0
Scheduled job has CPF4102 File LC096L1 in *LIBL with member *N not
found for Module APP400R WRKJOB shows library list includes library
BASLOC53
DSPPGMREF: BASLOC53/APP400R, BASLOC53/LC096L1, FmtLvl 4ECA238A7ABCA
DSPFFD: BASLOC53/LC096L1, FmtLvl 4ECA238A7ABCA This file is a logical
file I re-compiled yesterday, changing the key to be UNIQUE.
What did I do or neglected to do that caused this problem ?

--
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 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 message originates from Lincare Holdings Inc. It contains information which may be confidential or privileged and is intended only for the individual or entity named above.
It is prohibited for anyone else to disclose, copy, distribute or use the contents of this message.
All personal messages express views solely of the sender, which are not to be attributed to Lincare Holdings Inc., and may not be copied or distributed without this disclaimer.
If you received this message in error, please notify us immediately at MailAdmin@xxxxxxxxxxx or (800) 284-2006.
************************************************************************************************************************************************************************************************************

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






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact