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
3191 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 dbrm in db2 database?

1115

What os does db2 run on?

981

What is bind and rebind in db2?

1137

What is a storage group (stogroup)?

1246

How to access db2 tables in mainframe?

1051

Why do we bind in db2?

1210

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1101

What is a plan and package in db2?

1102

What are union and union all?

982

What is null indicator in db2?

1110

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2070

Define check constraint.

1076

How to retrieve rows from a db2 table in embedded sql?

1390

What is the difference between dbm cfg and db cfg file in db2 ?

1534

What is the maximum number of columns in a db2 table?

1283