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 vugen script modified after recording?

1115


How is each step validated in the script?

1102


What is extended log?

1071


How can you test the global servers with using loadrunner

2824


What are the information crating for each host?

1119


What do you mean by initialization of quota?

1153


What would be your recommendation to improve performance measure?

1070


What is a correlation?

1147


What are different types of vuser logs which can be used while scripting and execution? What is the difference between these logs? When you disable logging?

1049


How load runner interacts with the application?

1358


How you develop the database vuser script?

1094


What should be done to view parameter substitution in the execution log?

1006


What is difference between manual scenario and goal oriented scenario?

1071


How many types of vuser are available?

1064


How you set maximum number of vuser that a host can run?

1040