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
- 10939 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
can we view the access paths created by dbrm ? how ? thx
How can deadlocks be resolved?
What action db2 takes when a program aborts in the middle of a transaction?
What is the physical storage length of the data types date, time, and timestamp?
What is package in cobol db2?
Explain the contents that are a part of dclgen.
What is a system catalog table in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Define db2.
Explain how can you do the explain of a dynamic sql statement?
What is syscat in db2?
What is dpf in db2?
How is the value function used?
What is the difference between bind and rebind in db2?
