How we create a tables in DB2 ?Previously client has using
7 letters for user id,now he wants to increase the letters
from 7 to 12 for user id.How we can do it?

Answer Posted / ram prajapati

in any other database it is possible to alter the size of
the table's column but it is not possible do it in db2.
no modify command is there in db2 to be used in the
respective sql.
i'm a bit too sure about it so plz correct me when i'm wrong
with a reference link.plz.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is db2 a database?

742


What is the difference between bind and rebind in db2?

1190


What is the use of commit in db2?

821


What do you mean by rollback?

755


What is db2 command?

773


What is db2 plan table?

814


What is schema in db2?

781


What is cursor stability in db2?

1056


Comment whether the cursor is closed during commit or not.

866


What are the rules for db2 programming?

864


Define data page.

827


How do I optimize a query in db2?

830


Can we update view in db2?

771


What is the use of dclgen in db2?

802


How to check last update on table in db2?

818