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
- 10808 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / anish
for the 1st question:
v can create table by the COMMAND
CREATE TABLE table-name
column1 char(9)
.
.
...so on
And according to your installation u have to mention the
tablespace name & DB name.
for the 2nd question:
ALTER TABLE table-name
MODIFY USER_ID CHAR(12);
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How is deadlock resolved?
What is bind package and plan in db2?
What is ibm db2 used for?
What is db2 instance?
What does runstats do in db2?
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.
Mention the various locks that are available in db2.
What is buffer pool in the db2 database?
How do I change the column size in db2?
What is bind in db2?
What is cursor stability in db2?
Discuss about db2 bind?
How to create backup table in db2?
What are the prerogatives?
When the like statement is used?
