• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Use Field Names for Column Headings

    May 11, 2005 Ted Holt

    SQL/400 SELECT statements use the column headings that are stored as part of the file description when displaying or printing data. Sometimes I prefer to see the field names themselves used as column headings. I have found one method to make SQL use field names as column headings, but I wonder if you know of a better one.

    –Danny

    Danny is referring to files that are created with DDS, although column headings may also be defined with SQL’s LABEL ON command. Here’s an example of a few fields with defined column headings.

    A                                      UNIQUE
    A          R CUSTREC
    A            COMPANY        3P 0B      TEXT('Company')
    A                                      DFT(1)
    A                                      COLHDG(' ' ' ' 'Company')
    A                                      EDTCDE(1)
    A            CUSTNBR        5P 0B      TEXT('Customer account number')
    A                                      COLHDG('Customer' ' account' +
    A                                      '  number')
    A                                      EDTCDE(4)
    A            CUSTNAME      20   B      TEXT('Customer name')
    A                                      COLHDG(' ' 'Customer' 'name')
    A                                      ALWNULL
    

    Here’s a simple select against those fields.

    SELECT COMPANY, CUSTNBR, CUSTNAME
          FROM SOMEFILE
    

    Selecting these fields shows output like the following:

              Customer
               account  Customer
     Company    number  name
         1      20304   BIL'S GROCERY
         1      30405   TOM'S PHARMACY
    

    Danny’s method is to rename each field with its own name.

    SELECT COMPANY AS COMPANY, CUSTNBR AS CUSTNBR,
          CUSTNAME AS CUSTNAME
          FROM SOMEFILE
    

    Renaming in this manner produces the following output.

    COMPANY  CUSTNBR  CUSTNAME
        1     20304   BIL'S GROCERY
        1     30405   TOM'S PHARMACY
    

    I don’t know of any setting that tells SQL to use field names for column headings, so I do not have a better method than the one Danny is using.


    SQL/400 also picks up other formatting options from the file description. I have found it helpful to define edit codes and edit words in DDS, so that queried data is formatted nicely. For example, over an eight-digit, numeric field that contains a date in YYYYMMDD format, the following edit word is helpful.

    EDTWRD('    /  /  ')
    

    There are four blanks before the first slash for the year, two blanks between the slashes for the month, and two blanks after the second slash for the day. The value 20051231 displays as 2005/12/31.

    –Ted

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    ARCAD Software

    Embrace VS Code for IBM i Development

    The IBM i development landscape is evolving with modern tools that enhance efficiency and collaboration. Ready to make the move to VS Code for IBM i?

    Join us for this webinar where we’ll showcase how VS Code can serve as a powerful editor for native IBM i code and explore the essential extensions that make it possible.

    In this session, you’ll discover:

    • How ARCAD’s integration with VS Code provides deep metadata insights, allowing developers to assess the impact of their changes upfront.
    • The role of Git in enabling seamless collaboration between developers using tools like SEU, RDi, and VS Code.
    • Powerful extensions for code quality, security, impact analysis, smart build, and automated RPG conversion to Free Form.
    • How non-IBM i developers can now contribute to IBM i projects without prior knowledge of its specifics, while ensuring full control over their changes.

    The future of IBM i development is here. Let ARCAD be your guide!

    Watch Now

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Computer Lab and BOSaNOVA Bolster Thin Clients Help/Systems New CSI Tracks Down Runaway Jobs

    Leave a Reply Cancel reply

Volume 5, Number 19 -- May 11, 2005
THIS ISSUE
SPONSORED BY:

Advanced Systems Concepts
WorksRight Software
Linoma Software

Table of Contents

  • Use Field Names for Column Headings
  • Viewing and Printing the Euro Symbol
  • Scanning QSYSOPR for Selected System Messages

Content archive

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

Recent Posts

  • 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
  • Meet The Next Gen Of IBMers Helping To Build IBM i
  • Looks Like IBM Is Building A Linux-Like PASE For IBM i After All
  • Will Independent IBM i Clouds Survive PowerVS?
  • Now, IBM Is Jacking Up Hardware Maintenance Prices
  • IBM i PTF Guide, Volume 27, Number 24

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