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
- 10628 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
Mention the various locks that are available in db2.
What is db2 look?
What is the difference between spufi and qmf?
what is diffrence b/w file-aid tool and file-aid utility???
Highlight all the advantages that are attached to a package.
What is the function of logging in the db2 database?
Define check constraint.
What parameters are used to control the free space in DB2?
What are the contents of a dclmgen?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is the difference between nvl and coalesce?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is query_cache_limit?
What is difference between isnull and coalesce?
Is db2 a database?
