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
- 10665 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the maximum No of rows per page?
How to resolve deadlock issue
What is the maximum length of sqlca?
What is access path in db2?
Explain how can you do the explain of a dynamic sql statement?
What parameters are used to control the free space in DB2?
What is the difference between spufi and qmf?
How can you quickly find out the # of rows updated after an update statement?
Can we delete records from view?
How can the duplicate values be eliminated from db2 select?
What is phantom read in db2?
Give the name of some fields form sqlca.
What is the use of reorg in db2?
Mention some fields that are a part of sqlca.
How to find primary key of a table in db2?
