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...

While creating a table, by mistake you have given size of one
field as 10. But as per requirement size should be 8. What is
your next step?

Answer Posted / rahul

If table is empty then we alter this column to any length,
but if some data got inserted into the table then we can
also decrease the column length upto largest data size
available in that perticulat column.

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the benefits of using the db2 database?

1172


What is the meaning concurrency in the db2 database?

1072


What is multi row fetch in db2?

1002


How is the value function used?

1097


What is a bind card?

1157


List down the data types in the db2 database.

1054


My sql statement select avg(salary) from emp yields inaccurate results. Why?

1051


What is meant by union and union all?

962


What r the comman abends in db2, jcl and cobol???????

2220


What is node in db2?

1005


What is ibm db2 connect?

946


How can deadlocks be resolved?

905


What is plan in cobol db2?

1079


Mention the different locking levels that are available in db2.

1092


What is rebind in db2?

1010