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
- 11129 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
What is a db2 collection?
What is runstats db2?
what is utility for parm lib
Is db2 relational database?
How to find the number of rows in a db2 table?
What is precompiler in db2?
What are db2 tables?
What does db2 blu stand for?
Explain the contention situations caused by locks?
What is the difference between using bind () and rebind () methods of naming class?
What does runstats do in db2?
Mention the definition of cobol in varchar field.
What is host variable?
Is schema the same as database?
When the like statement is used?
