Hi there,

It sounds lazy, but I just wonder instead of listing all the columns, can I select all but exclude one column in select statement?


Thanks

ha ha ha
i dont think so...

regards
another lazydba

yes, by listing only the columns that you want

Try "select *-1 from mytable where..." - this just might work...

that's pretty funny

but april 1st is still quite a ways down the road...

But this only works if the last column is omited.


Ok, get serious:
You can write an SQL from catalog table to get all columns:
db2 select colname from syscat.columns where tabschema='schema' and tabname='TEST'

Hope this helps,
Grofaty

It is good style anyways to list columns explicitly and not rely on "SELECT *".