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.

google for "user view"

Thank you for replaying....Pls allobarate ..

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

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?

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

I think the OP mean "elaborate"...

Andy