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
What is the difference between plan and package in db2?
What are packages in db2?
How does coalesce work?
What is declare cursor?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Can one database have multiple instances?
How to run db2 command in windows?
What is release/acquire in bind?
What is an instance in db2?
What is with ur in db2?
Name the various locking levels available?
What is concurrency?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How will you return the number of records in table?