MVSFORUMS.com

babun

how can we deleted un-used column's in a database table ?
can you people give me more solutions reg this ...

move is one technique ,,,do we have any other option to do ?
_________________
babu

Cogito-Ergo-Sum · Posted: Thu Aug 04, 2005 3:58 am Post subject:

I am sorry, but I do not understand either of the posts.

batu544 · Beginner Joined: 02 Aug 2005 Posts: 75 Topics: 27

Hi,
As far as my knowledge , U can't delete a column from a table in DB2.

but in othe database lke ORACLE u can do it by using ALTER command.

I think one way to do is create a table having all the required column and load that table.
_________________
Regards,
batu

karthikeyan · Posted: Thu Aug 04, 2005 12:11 pm Post subject: You cant Drop

Hi
You can drop a column in the Oracle 9i but not in the earlier versions
But in DB2 we dont have that provision.So u have use that move what u said earlier

kolusu · Posted: Thu Aug 04, 2005 12:16 pm Post subject:

babun · Posted: Fri Aug 05, 2005 2:25 am Post subject:

according to come sources,, the move means ,,,we can move the columns except un-used columns into some other table through move...n delete that table which having with un-used columns..
un-used column's ,,client said i am not going to use some of the columns in future n ask to delete those 2 columns,,,that is it..
u r opinion's are invited..
_________________
babu

batu544 · Beginner Joined: 02 Aug 2005 Posts: 75 Topics: 27

1. one way is create a new table except that unused column and load that table.

2. U can create a view by taking only used columns .

Very Happy

_________________
Regards,
batu

kolusu · Posted: Fri Aug 05, 2005 5:59 am Post subject:

batu544 · Beginner Joined: 02 Aug 2005 Posts: 75 Topics: 27

kolusu,

i didn't say anything like this....

Embarassed

_________________
Regards,
batu

Mervyn · Posted: Fri Aug 05, 2005 8:43 am Post subject:

A simple case of mistaken identity!

Don't take it too hard. Mr. Green

Cheers,
Merv
_________________
The day you stop learning the dinosaur becomes extinct

kolusu · Posted: Fri Aug 05, 2005 8:50 am Post subject:

batu544,

My sincere apologies. sorry !

I edited the post to reflect the right person.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

schintala · Posted: Fri Aug 05, 2005 9:52 am Post subject:

db2move is a data movement tool that can be used to move large numbers of tables between DB2 databases. This command works in DB2 for LUW applications. I don't think there is anything called DB2 MOVE in z/OS environment.

batu544 · Beginner Joined: 02 Aug 2005 Posts: 75 Topics: 27

ha..ha... u ppl also don't take it too hard.... Very Happy

_________________
Regards,
batu

Manas Biswal · Posted: Fri Aug 05, 2005 1:09 pm Post subject:

schintala,

Can the db2move utility on UDB export and import selected columns? I thought that it could only move whole tables.

Of course, for DB2 on S/390, the only option is to drop and recreate the table.

Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948)

schintala · Posted: Fri Aug 05, 2005 3:05 pm Post subject:

Yes, you are right. DB2MOVE utility only to move the whole table. It can't used to move part of the table columns.