Results 1 to 7 of 7
  1. #1
    Join Date
    May 2009
    Posts
    2

    Thumbs down Unanswered: How to display all columns values except one column values

    Hi All,

    I want to display all columns values except one column values in db2 UDB tables

    Ex: I have table with name table1 having 100 coulmns col1,col2 etc...now I want to display only 99 columns values

    If we use select * from table1-->its display all 100 volumns values instead of this I want to display only 99 columns values ..

    Please help me..

    Thank you.

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    google for "user view"

  3. #3
    Join Date
    May 2009
    Posts
    2
    Thank you for replaying....Pls allobarate ..

  4. #4
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    How about you do not do select * To begin with.

    Can you explain what is the business need to display all 99 columns? How many screens would it take to accomplish this?

    If you do not know about views, you should talk to your DBA and have them crete you one.

    For more info on the it ftp://ftp.software.ibm.com/ps/produc...S/db2s2e90.pdf
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  5. #5
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    What is the meaning of "allobarate"?
    I'm not well at English, and I couldn't fund the word on my dictionaries.
    Would someone please explain the word?

  6. #6
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Quote Originally Posted by pb18798
    I want to display all columns values except one column
    You'll have to write out all 99 column names after the SELECT keyword.
    SQL does not have a shortcut for this.
    (It shouldn't have had the "SELECT *" shortcut, neither, but that's an other discussion
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  7. #7
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Quote Originally Posted by tonkuma
    What is the meaning of "allobarate"?
    I'm not well at English, and I couldn't fund the word on my dictionaries.
    Would someone please explain the word?
    I think the OP mean "elaborate"...

    Andy

Posting Permissions

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