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?
- 1 Answers
- 21228 Views
- I also Faced
- E-Mail Answers
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 |
HI ALL CAN ANYBODY GIVE THE GUIDANCE ABOUT SILK PERFORMER AND SUGGEST ANY WEBSITES FOR GUIDANCE REGARDING SILK PERFORMER. CAN ANYBODY MAIL ME AT siva2574@gmail.com THANKS & REGARDS SIVA.
What are the four selection methods when choosing data from a data file?
How to increase the load on Server when number of users restricted?
what is the procedure to create test case in web performance load testing and how to download loadrunner and QTP
What is report header and what are the information contains?
What are the changes you can make in run-time settings?
During run time where the hosts saves the files?
What is the function for Nested Transaction in Load Runner?
we have Unix monitors in LR by default. if i want Linux and Solaris monitors....what i do.. unix is working for Linux and solaris?
what is the difference bet ween loadrunner 6.0 and loadrunner 7.5?
Hi All, 1. How to Run QTP Scripts from Loadrunner, can u plz give steps in detail 2. Can we put LR functions in QTP script...? 3. While Executing QTP Script in LR, can we use the Correleation concept...?
what are the parameters in Load Runner?
WinRunner 
