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

Suppose if I need to update a column, how you do that using
cursor?

Answer Posted / bobby

continuation of previous answer,

after cursor declaration, open the cursor and fetch the cursor. When the condition for update is satisified isue EXEC SQL UPDATE CURRENT OF.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List some fields from sqlca?

1062


What is query_cache_limit?

977


Is ibm db2 free?

1019


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2222


When the like statement is used?

1228


How does cobol compile db2 program?

1075


What is the difference between nvl and coalesce?

1067


What is dbrm? When it will be created?

1035


What is db2 instance?

1110


What is coalesce in db2?

1140


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2335


What is the maximum No of rows per page?

1074


What is the physical storage length of timestamp data type?

1102


What does db2 mean?

1022


What db2 400?

1204