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 / 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
Is the primary key a clustered index?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is the picture clause of null indicator variable?
What is cursor stability in db2?
What is temporal table in db2?
What is cursor in dbms?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is the physical storage length of date data type?
What is the syntax for creating a table in the db2 database?
what is db2 restart?
How to run db2 command in windows?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How to retrieve rows from a db2 table in embedded sql?
Explain in detail about buffer manager and its functionalities?
What is bind package and plan in db2?