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?
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
What is db2 connect?
How do you find the maximum value in a column in db2?
How does coalesce work?
List out the data types available.
What are db2 objects?
Is ibm db2 open source?
What is the information associated with sysibm.syslinks table?
What are the different types of base tables?
Can we insert update delete in view?
Explain about open switch business continuity software?
What is load replace in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Explain various types of locks in db2?
What is db2? Explain.
What is null in db2?