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

what is think time when u will use it?

12 Answers   IBM,


What are the parameters in Load Runner?

1 Answers  


What is the purpose of running the scenario?

0 Answers  


Hi Guys, Is it possible to merge and compare graphs from different scenarios in load runnner ?

7 Answers  


In a web application transaction response time comprises of some sub times like time from web browser to web server thn to application server and then time taken to get response from the database and back to the web browser following the same path.How to get these sub times distinctly in LR analysis?

0 Answers  


Hi I want to learn Performance testing using load runner..Can anyone suggest me which is the best institute for load runner in bangalore??

6 Answers  


Where are automatic correlation options set?

0 Answers  


How you set maximum number of vuser that a host can run?

0 Answers  


Does the Tool generates think time for the standard value defined in script with respect to server response when we use option use random think time 50 - 150%. or will tool simply calculates value randomly for the standard think time defined in script.

1 Answers  


what is loadrunner?

1 Answers   Wipro,


What is running virtual user graph?

0 Answers  


Which is the best institute for LOAD RUNNER in HYD? what is the market for LR present?

13 Answers  


Categories