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 web protocol& webservices protocol .Can u just give the examples.

2 Answers   EDS,


ingenaral realtime prjoects how much load and bottile neck will take part in a project?(Chandana)

1 Answers   TCS,


Difference b/n Loadrunner and Performance center?

2 Answers   Cap Gemini, IBM,


explain about goal-oriented scenario in controller

3 Answers   CGI,


Where do you set Iteration for Vuser testing?

5 Answers  


Can u plz tell me what r the functions available in load runner and how to write userdefined functions and what are they?

2 Answers  


How do you perform functional testing under load?

2 Answers  


Why do you create parameter?

0 Answers  


How can we edit the vuser script?

0 Answers  


In a web server, database and network are all working fine and now, where could be the problem?

0 Answers  


What is the difference between Set_window() and _set_window ()?

1 Answers   Google, MBT,


on what basis you will provide the recommendations to upgrade the hardware?

2 Answers   SumTotal,


Categories