Naming Conventions

"Travis Beames" <[email protected]>
Newsgroups gmane.comp.systems.as400.jbausers
Message-ID <0852511775684047BC82E0CC35B745F8013A0A4D@mtgwsvr1.martoggco.local>
I've looked everywhere on the internet but cannot find anything on a
standard for handling database object naming, so I'd thought I'd turn to
the best in the business. 
 
I was hoping you could supply some rules to name database objects taking
into consideration long & short/system (10 characters) names. 
 
The reason is we are planning on moving from the old DDS to DDL SQL
statements saved in source members saved in something like a QSQLSRC
source file. 
 
The following objects are of interest: 

*	Tables 
*	Columns 
*	Indexes 
*	Views 
*	Constraints 
*	Triggers 
*	SQL Procedures 
*	SQL Functions 

Any recommendations for what to store in & where to store the source
files would also be greatly appreciated.

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.