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
- 9301 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 db2 stogroup?
Define db2.
What r the comman abends in db2, jcl and cobol???????
How do you find the maximum value in a column in db2?
What are foreign keys in db2?
What is the advantage in De-normalizing tables in DB2?
Highlight all the advantages that are attached to a package.
Which components manage deadlocks in db2?
How do I connect my db2 database to ibm?
Define check constraint.
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is the use of db2?
What is the use of db2 optimizer?
How is a typical db2 batch pgm executed?
can all users have the privilage to use the sql statement select * (dml)?
