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?

Answers were Sorted based on User's Feedback



How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to i..

Answer / 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

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to i..

Answer / shailendra

i think, the size of variable is not possible to change,
please correct me if i am wrong.

so for the solutionwe can creat new table with change of
the size of user_id char(12)


and if you want the same name of table
step1 >creat a table for interface perpose with user_id char
(12)

2> insert all the data in the interface table
3> delete the main table.
4> create table with same name of main table with
user_id char(12)
5> insert data from interface table to main table.


now i think it will work.

Is This Answer Correct ?    3 Yes 1 No

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to i..

Answer / guest

It is always possible to increase the size of the variable.
It is not possible to decrese the size.

Is This Answer Correct ?    2 Yes 1 No

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to i..

Answer / ram prajapati

in any other database it is possible to alter the size of
the table's column but it is not possible do it in db2.
no modify command is there in db2 to be used in the
respective sql.
i'm a bit too sure about it so plz correct me when i'm wrong
with a reference link.plz.

Is This Answer Correct ?    1 Yes 0 No

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to i..

Answer / ratheesh nellikal

Hi Ram Prajapati ,

In db2 (esp in version 9.5) it is poosible to increase the
size of a column without loosing the data.
But u can not decrease the size.

Cheers ,
Ratheesh Nellikkal

Is This Answer Correct ?    1 Yes 0 No

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to i..

Answer / hi

Yes, it's possible to increase/decrease the size. While
decreasing, need to make sure that none of the records
present in the column conflict the modification. e.g. to
reduce the size of the column which is CHAR(6) to CHAR(4),
with one of the record value as 'ABCDE' will give an error.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More DB2 Interview Questions

How is the value function used?

0 Answers  


How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,


explain about index with examples

2 Answers   Syntel,


Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,


How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  






Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

2 Answers   IBM,


Is schema the same as database?

0 Answers  


What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  


what types of copies can be made with the COPY Utility ?

1 Answers  


What is a host variable?

3 Answers  


What is a plan and package in db2?

0 Answers  


What does DSNDB07 database do?

2 Answers  


Categories