Drop all columns except the few I want

[gsnidow]

Greetings all.  I'm hitting a DB2 table that has around 100 columns, and I only want 5 of them.  Is there a quick way to drop them all excluding the 5 I want, without having to explicitly type them all out in a drop statement?

Greg

[ballardw · Accepted solution]

Instead of DROP=  use KEEP= for the variables you want.

The pain is when the desired number is about half of the variables...

[gsnidow]

Thank you, I knew it had to be something easy like that.

Greg