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


Please Help Members By Posting Answers For Below Questions

What is the difference between plan and package in db2?

860


What are packages in db2?

814


How does coalesce work?

773


What is declare cursor?

854


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

881


Can one database have multiple instances?

831


How to run db2 command in windows?

910


What is release/acquire in bind?

892


What is an instance in db2?

798


What is with ur in db2?

1052


Name the various locking levels available?

854


What is concurrency?

939


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.

2997


Is it possible to create an Instance in DB2 using DB2 Control Center ?

866


How will you return the number of records in table?

730