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 happens in bind step in a db2 program?
Explain in detail about buffer manager and its functionalities?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Which isolation level provides highest data integrity?
How do I add a column to an existing table in db2?
What is the physical storage length of the data types date, time, and timestamp?
What is drop table?
How can you count the number of rows from a table tab?
What is buffer pool and list some of them?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
Explain the function of data manager.
What is null in db2?
i want to maintain uniqueness on pdf without make lf??????????
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What db2 400?