• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Don’t Let SQL Name Your Baby, Take 2

    March 5, 2008 Hey, Ted

    Don’t Let SQL Name Your Baby gave some good advice on tackling the problems created by column names longer than 10 characters. Table names of more than 10 characters can also cause problems, especially if you need to add the same table on multiple systems. Plus, if you want to do updates in an RPG program, it’s nice to have a record format name different from the table name.

    –Tim

    Tim points out another discrepancy between the System i’s QSYS.LIB file system and relational databases that run on other systems. Using SQL, you can create a table with a very long name, but object names can’t be more than 10 characters long. Here’s how you might create a table (physical file) with a very long name.

    create table tholt/AVeryLongTableName
       (key dec(3), data char(10))
    

    In order for you to access that file from commands like Copy File (CPYF) and Run Query (RUNQRY), the system generates a name, which in this case is something like AVERY00001. If you don’t like that name, you can use CL’s Rename Object (RNMOBJ) command to rename the physical file.

    rnmobj obj(tholt/avery00001) objtype(*file) newobj(averylong)
    

    Or you can use SQL’s RENAME command.

    rename table avery00001 to system name averylong
    

    In either case, the new i5/OS-compliant file name is AVERYLONG.

    Tim has what I consider to be a better method. First, create the table using a desired record format name.

    create table rtesttbl etc. etc. etc.
    

    Then rename it.

    rename rtesttbl to testing_long_sql_names
    for system name testtblf
    

    After this operation, physical file TESTTBLF, with record format RTESTTBL, has a long SQL name of TESTING_LONG_SQL_NAMES.

    –Ted

    RELATED STORY

    Don’t Let SQL Name Your Baby



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    OCEAN User Group

    OCEAN TechCon25 Online

    It’s an Exciting Time for IBM i !

    July 16 & 17, 2025 – ONLINE

    Two virtual days of learning, presented by an outstanding group of IBM’ers and IBM Champions, featuring leading-edge topics.

    FREE for OCEAN members!

    Register NOW!

    Annual (12-month) Individual OCEAN Memberships are $80 and a Corporate Membership is $250. A Corporate Membership would allow your entire company to have full access to the OCEAN website & video library and to attend OCEAN events at member rates. Act now because rates are increasing on August 1, 2025.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    COMMON:  Join us at the annual 2008 conference, March 30 - April 3, in Nashville, Tennessee
    ARCAD Software:  Dynamic, world-class ALM on and around the System i
    New Generation Software:  Look at NGS-IQ before replacing Query/400

    IT Jungle Store Top Book Picks

    Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
    Getting Started with PHP for i5/OS: List Price, $59.95
    The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
    The System i Pocket RPG & RPG IV Guide: List Price, $69.95
    The iSeries Pocket Database Guide: List Price, $59.00
    The iSeries Pocket Developers' Guide: List Price, $59.00
    The iSeries Pocket SQL Guide: List Price, $59.00
    The iSeries Pocket Query Guide: List Price, $49.00
    The iSeries Pocket WebFacing Primer: List Price, $39.00
    Migrating to WebSphere Express for iSeries: List Price, $49.00
    iSeries Express Web Implementer's Guide: List Price, $59.00
    Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
    Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
    Getting Started with WebSphere Express for iSeries: List Price, $49.00
    WebFacing Application Design and Development Guide: List Price, $55.00
    Can the AS/400 Survive IBM?: List Price, $49.00
    The All-Everything Machine: List Price, $29.95
    Chip Wars: List Price, $29.95

    Cleo Updates B2B Communications Software ACOM Updates EZ Content Manager

    Leave a Reply Cancel reply

Volume 8, Number 9 -- March 5, 2008
THIS ISSUE SPONSORED BY:

Help/Systems
SPSS
Guild Companies

Table of Contents

  • Performance Advice from a Mysterious Friend
  • Don’t Let SQL Name Your Baby, Take 2
  • Admin Alert: When System i Ethernet Cards Stop Broadcasting

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • With Power11, Power Systems “Go To Eleven”
  • With Subscription Price, IBM i P20 And P30 Tiers Get Bigger Bundles
  • Izzi Buys CNX, Eyes Valence Port To System Z
  • IBM i Shops “Attacking” Security Concerns, Study Shows
  • IBM i PTF Guide, Volume 27, Number 26
  • Liam Allan Shares What’s Coming Next With Code For IBM i
  • From Stable To Scalable: Visual LANSA 16 Powers IBM i Growth – Launching July 8
  • VS Code Will Be The Heart Of The Modern IBM i Platform
  • The AS/400: A 37-Year-Old Dog That Loves To Learn New Tricks
  • IBM i PTF Guide, Volume 27, Number 25

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle