Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2003
    Location
    AUS
    Posts
    26

    Question Unanswered: Display Results Without Column Header

    hi all,
    is there anyway of displaying the results without column header in aselect query
    example
    db2 => select * from test
    name age
    xxxxx 29
    yyyy 35
    zzzz 23

    into
    db2 => select * from test

    xxxxx 29
    yyyy 35
    zzzz 23

    cheers
    Melb

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Yes there is a parameter that can be set to do that. I am too lazy to look it up for you, so check the Command Reference manual.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2003
    Location
    AUS
    Posts
    26
    Thanks marcus.
    But I can't find it in the manual. would you mind posting the exact syntax.

    cheers

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If you go to the thread called Useful DB2 Stuff, you can find the link to download the DB2 manuals. You need the Command Reference. Look in the chapter that deals with the Command Line Processor (CLP). If you are dealing with jdbc or some other interface, you might check out the applciation development manual.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    You can find the info you want, plus a few other command line options at
    http://www.db2click.com/scribble.htm

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  6. #6
    Join Date
    Sep 2003
    Posts
    85
    db2 -x "select ....."
    will not produce the headings but just the column(s) desired.
    Ruby
    Last edited by rubystep; 06-09-04 at 15:10.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •