Re: SQL Naming Conventions

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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