ALTER TABLENAME ADD COLUMN <COLUMN NAME> <DATATYPE>(<

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

Question Posted / azharuddinsyed

1 Answers
3270 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / azharuddinsyed

ALTER TABLENAME
ADD COLUMN <COLUMN NAME> <DATATYPE>(<SIZE>)

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is difference between rollback and commit?

1205

Explain correlated sub-queries.

1096

What does runstats do in db2?

1188

What is dbrm library?

1117

How to compare data between two tables in db2?

1140

How to connect to db2 database from windows command line?

1139

Explain package in db2 and its advantages?

1275

What is bind package and plan in db2?

1109

What is the difference between nvl and coalesce?

1109

What is cloudant database?

1158

How to rename a table in DB2 ?

1147

What is db2 purescale?

1054

Highlight all the advantages that are attached to a package.

1169

What is a db2 cursor?

1110

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2297