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

How often you do the load test in your current project?

2 Answers   Patni,


why do u need a parameterize fields in ur virtual user script ?

5 Answers  


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

0 Answers  


In what situation the throughput will decrease even the hits per second increases???

1 Answers   HCL, IBM,


Difference b/w URL and HTML modes in LR?

2 Answers  


While the script is running we find some values that may need to be correlated? Is it possible to do manual correlation for those values?

0 Answers  


where do you save u r scripts in Load Runner?

2 Answers   TCS,


What is Perfomance Tuning? where can we use this

5 Answers   AZTEC,


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  


Specific Performance Monitoring counters for, 1. Web Servers (IIS, Apache etc) 2. Application Servers (Weblogic etc) 3. Database Servers a. Oracle Database b. Sybase c. SQL Server d. DB2

1 Answers  


How many vusers are required for load testing?

0 Answers  


How to schedule a scenario?

0 Answers  


Categories