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

By default how many virtual user are there in LoadRunner?

2 Answers  


what is standalone mode running?

2 Answers  


What Is The Cofidence Level In Load Runner?

1 Answers   Covansys,


You want to have each step in your script measured as a transaction in the controller and not shown in the replay log in vugen. How can you accomplish this?

0 Answers  


How to upload media use loadrunner? I record the script but it fail because the top of document is invalidation.How to solve the problem?Which one know the answer please tell me. Thanks!

0 Answers   Adobe,


i dnt kw loadrunner but i want kw.plz can any 1 help me

1 Answers  


if thoughput will be high /low what will be the problem?

1 Answers   Ness Technologies,


what is the language(Script) use in Loadrunner script?

6 Answers  


Where do you set Iteration for Vuser testing?

5 Answers  


different types of performance testing

1 Answers   Accenture,


Where we can analyse the perfomance graph in Loadrunner? (Chandana)

4 Answers   IBM,


In which scenario, we should use "Vuser as Process" rather than "Vuser as thread" and what is benefit in this case?

2 Answers   Orange,


Categories