MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » June 2014

Re: Naming standard for indexes



fixed

I assume that's for the short system name. What about long names?

(note this assumes you use long names for your tables)

Charles


On Sat, Jun 28, 2014 at 12:06 PM, Gary Thompson <gthompson@xxxxxxxxxxx>
wrote:

Same here as Paul says, except we don't use X for Index.

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
PaulMmn
Sent: Saturday, June 28, 2014 9:54 AM
To: Midrange Systems Technical Discussion
Subject: Re: Naming standard for indexes

Our file names generally end with a P for Physical, Lnn (L01 L02 L03 etc)
for logicals.
We've more or less adopted Xnn (X01 X02 X03 etc) for indexes. But it's
not a hard and fast rule-- some indexes use the L1 2 3 naming.

--Paul E Musselman
PaulMmn@xxxxxxxxxxxxxxxxxxxx
.
.


At 11:43 AM -0400 6/28/14, Charles Wilt wrote:
ÐAll,

I'm just curious as to what naming standards if any you follow for
indexes.

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







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