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

difference between latency and transaction response time

0 Answers   Maveric,


What is Workload? Can anyone explain in detail?

5 Answers   TCS,


Hi all, I am new to Load Runner. I have run the load runner and i got analyzed reports/graphs. But i am very much confused about how to analyze those graphs. Can any one help me out this problem?

0 Answers  


If we want to know the size of each component in system how?

0 Answers   AZTEC,


how many performance test scripts have you written? what was the performance issues you had? what did you recommended to that issues? what kind of performance requirements did you have? how did you tune the system for performance? how did you ramped up the users? how did you find the bottlenecks of the system? did you find any coding issues and if yes what kinds of?

1 Answers  


How is the Best Faculty for LoadRunner in Hyderabad

6 Answers  


what is the 90% ile time in the analysis results?

4 Answers  


Explain performance testing life cycle.

0 Answers  


Suppose ur app server is .net server. In that connection pool is related to memory ?explain how?

0 Answers   EDS, Satyam,


How many section database vuser script have?

0 Answers  


we have auto correlation, so why do we need to perform the manual correlation

2 Answers  


Do we consider firewall in performance testing? If so where and why and what we will do with firewall in testing?

1 Answers  


Categories