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.