Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10663 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / shailendra
i think, the size of variable is not possible to change,
please correct me if i am wrong.
so for the solutionwe can creat new table with change of
the size of user_id char(12)
and if you want the same name of table
step1 >creat a table for interface perpose with user_id char
(12)
2> insert all the data in the interface table
3> delete the main table.
4> create table with same name of main table with
user_id char(12)
5> insert data from interface table to main table.
now i think it will work.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain the function of data manager.
What does a deadlock mean in DB2?
What is a db2 tablespace?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is the role of data manager in the db2 database?
Explain how can you do the explain of a dynamic sql statement?
Define db2 and its databases?
How to resolve deadlock issue
What is netezza database?
What is a buffer in memory?
Which component is responsible for db2 startup and shutdown?
When reorg is used?
Outputs of explain are with matchcols = 0. What does this signify?
Are view updateable?
How is deadlock resolved?
