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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How is automated correlation configured?

1050


What is vugen recording and scripting?

1138


What do you mean by creating vuser script?

1106


What is elapsed time in load runner?

1248


How will you stop the execution of a script on error?

1173


What is think time?

997


What is loadrunner agent?

1170


Difference b/w 9.1 and 9.5 Versions in LoadRunner?

7433


Why vugen is used in lr?

1065


What are all the types of goals in goal-oriented scenario of load runner?

1130


How do you identify which protocol to use for any application?

1074


What kind of problem we can face regarding hardware, software, network and memory bottleneck during the performance test?

1118


Hi can anyone help with projects using load runner. I learnt loadrunner but don't have a hands on experience on it.. it will be very much helpful if some can help me up with a project. can email me: priya.joslic@gmail.com

1743


What is the modular approach of scripting?

1490


What is stand-alone mode?

1113