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

Why select is not preferred in embedded sql programs?

1312


What does a deadlock mean in DB2?

1180


What is cascading rollback?

1221


Define declaration generator (dclgen).

1124


Can you use max on a char column?

1105


What is the difference between nvl and coalesce?

1071


What are foreign keys in db2?

1116


What is the reason behind not using select * in embedded sql programs?

1128


How do I connect my db2 database to ibm?

1061


Which component is responsible for db2 startup and shutdown?

1044


What is ibm db2 connect?

1012


How does coalesce work?

1035


What is buffer pool?

1114


What is explain plan in db2?

1010


What is a collection in db2?

1047