Re: SQL Naming Conventions -- RPG400-L

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

Get a copy of this book, Joe Celko's "SQL Programming Style".

Note that for IBM i, current best practice would be to assign a long SQL
name along with a 10 character short name.

Charles

On Fri, Feb 26, 2016 at 1:25 PM, <BButterworth@xxxxxxxxxxxxxx> wrote:

Hello All,

We are working on an overall modernization strategy in our shop and part
of that is considering SQL naming standards. I've been looking through
books and online for ideas, including midrange.com, but not finding a
whole lot. Does anyone have references to good books or online articles
that would lend some assistance? Anyone want to share the standards being
used in their shop? To get an idea of what I am talking about, here is an
article:

https://launchbylunch.com/posts/2014/Feb/16/sql-naming-conventions/

With DB2 for i, we traditionally have been limited to 10 character system
names for tables and columns, but we are using DDL more and with the newer
features in RPG IV it isn't a big deal to use the longer names now, though
we are not opposed to working within the 10 character limit. I am just
trying to survey different ideas to develop a sensible standard that works
for our group.

Thanks,
Blake

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.