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

In db2, how do you insert multiple rows in 1 query using a.)
Cursors, b.) Normal query?? Give syntax for both.

Answer Posted / uma

We can't insert multiple row in single query for the we
have to use cursor.

Is This Answer Correct ?    5 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a Foreign Key?

1104


Define predicate?

1142


How do I import a csv file into db2?

998


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1742


List out the three types of page locks that can be held.

1151


What are the uses of db2 optimizer?

1301


What is the difference between cursor stability and repeatable read isolation levels?

1187


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3584


How do you find the maximum value in a column in db2?

1112


what is the sqlcode -501

13173


How to fetch the last row from the table in SQL (db2)?

1661


Where do you specify them?

1292


What is load replace in db2?

1005


What's The Percentage Free Space ?

1233


What is view db2?

1085