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

Answer Posted / azharuddinsyed

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to execute stored procedures?

612

What is ibm db2 database?

524

What is the use of runstats in db2?

567

What is a cursor in programming?

583

What is meant by dclgen?

613

Mention the definition of cobol in varchar field.

679

What is isolation level in db2?

571

Which isolation level provides maximum concurrency?

653

What is the use of value function?

612

What is the picture clause of null indicator variable?

682

How is the value function used?

595

What is netezza database?

561

Can you tell me how can you find out the # of rows updated after an update statement?

602

What is the role of the data page in the db2 database?

579

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3109