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

Describe configurations of both servers? Here what r two different servers.

3 Answers   EDS,


What is the use lr_abort function?

0 Answers  


How To Identify Performance Testing Requirements ?

5 Answers   Polaris,


LOAD RUNNER 9.5 TRAINING AT KUKATPALLY

1 Answers  


Performance testing Training

3 Answers   Wise Info,


How do you measure the current VUsers in LoadRunner?

0 Answers   Allianz,


How do you write user defined functions in LR? Give me few functions you wrote in your previous project?

1 Answers  


How can we test the performance of a stand alone music player. It also interacts with web, for few of the functionalities. Can we use Load Runner or Silk Performer for the same? Kindly guide me on this.

1 Answers   AOL,


Case1: recording script, Login in Vuserinit,Body in Action and Logout in Vuserend. Case2: recording Login,Body and Logout in Action itself. Run both the scripts. What are the difference u will find? Is there any difference?

5 Answers   Patni,


What is load testing?

6 Answers   Ordain Solutions,


can we use Load Runner to perform load testing on client- server application developeds in java? if yes, which protocol to use and how to go for it?

1 Answers  


Recognize the debugging tools available in vugen?

1 Answers   AppLabs, Infosys,


Categories