Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a db2 package?

1128


Which is faster delete or truncate?

1177


What is the use of db2?

1114


What is drop table?

1071


What is rebind in db2?

1119


can we view the access paths created by dbrm ? how ? thx

7207


i want to maintain uniqueness on pdf without make lf??????????

2204


How do I change the column size in db2?

1210


What are types of indexes?

1189


What is the usage of open cursor command?

1151


How do I import data from excel to db2?

1130


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1142


How do I add a column to an existing table in db2?

1083


Define check constraint.

1134


What are union and union all?

1039