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
- 10868 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 do you mean by rollback?
What is db2?
What is a storage group (stogroup)?
What is dbrm? When it will be created?
Can we update view in db2?
Why cursor is used in db2?
what is a corelated subquerry?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is meant by explain?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is the role of union all and union
What is the result of open cursor statement?
List down the data types in the db2 database.
What is null indicator in db2?
can we view the access paths created by dbrm ? how ? thx
