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 to execute set of multiple SQL queries in Load Runner?
Which component in LR would be used to run the SQL Queries?



How to execute set of multiple SQL queries in Load Runner? Which component in LR would be used to r..

Answer / rajat

Follow below mentioned steps in order to execute query
through LR script-

(1) Establish conn with DB
lrd_open_connection(&Con1, LRD_DBTYPE_ORACLE, "bb",
"lion", "hammer", "", 0, 0, 0);

(2) Enter query
lrd_stmt(Csr1, "select ename from employee where
(sal>=1000)\n", -1, 1, 1, 0);

(3) lrd_bind_col(Csr1, 1, &D21_ENAME, 0);

(4) Execute query
lrd_exec(Csr1, 0, 0, 0, 0);

(5) lrd_fetch(Csr1, -3, 1, 0, PrintRow24, 0);


(6) lrd_close_cursor(&Csr2, 0);

(7) lrd_close_connection(&Con1, 0, 0);

Is This Answer Correct ?    6 Yes 1 No

Post New Answer

More Load Runner Interview Questions

How to configure yahoo cookies in load runner?

0 Answers  


What is scenario default?

0 Answers  


Is it possible to run Loadrunner tests in laptop? How?

3 Answers  


How do you test pop up with LR? My whole application running on pop up. Its a JSP page written on pop up window.

1 Answers   Infosys, SGS,


How to create a host list for a scenario?

0 Answers  


what r DLL functions in loadrunner?where these present?when &why we use these?

1 Answers   Symphony,


What is vugen recording and scripting?

0 Answers  


What is the difference between web_reg_find and web_find?

0 Answers  


Can someone suggest me which is the best institute in Hyderabad for Load runner and Selenium

3 Answers  


Is there any special setting required in internet explorer or laod runner VUGen to prepare script in load runner using seibel web protocol. is it same like web-Http/Html?

0 Answers  


can we use Quality center in Load runner ? and what is the latest verson of Load Runner ?

2 Answers  


You do Scalability testing in Load testing or Stress testing?

0 Answers   IBM,


Categories