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
What is the difference between spufi and qmf?
What is ibm db2 used for?
What is the syntax for creating a table in the db2 database?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is dbrm? When it will be created?
What is the role of data manager in the db2 database?
What is the role of the data page in the db2 database?
Define db2.
How do I add a column to a table in db2?
How do I create a view in db2?
How can you count the number of rows from a table tab?
How to check last update on table in db2?
What is the difference between cursor stability and repeatable read isolation levels?
Explain the function of data manager.
What is dclgen (declaration generator)?