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
- 9300 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
What is the physical storage length of timestamp data type?
What is the maximum size of varchar data type in db2?
Which are the db2 tools to protect integrity of the database?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How to fetch the last row from the table in SQL (db2)?
Why do we bind in db2?
What is copy pending status in db2?
How to take backup of table in db2?
i want to maintain uniqueness on pdf without make lf??????????
How to find the number of rows in db2 tables?
Why select is not preferred in embedded sql programs?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Explain various types of locks in db2?
Is db2 free?
What is the cobol picture clause of the db2 data types date, time, timestamp?
