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?
- 6 Answers
- 8892 Views
- Wipro, I also Faced
- E-Mail Answers
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
Mention the location where the output received from explain statement is stored.
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
How do I add a column to an existing table in db2?
On which levels locks can be applied?
What is page size in db2?
What is difference between isnull and coalesce?
How to resolve deadlock issue
What is cascading rollback?
What does reorg do in db2?
what is db2 restart?
What are host variables in db2?
What is db2 bind process?
What types of tables are there in the db2 database?
Which isolation level provides highest data integrity?
Who uses db2?
