How to execute set of multiple SQL queries in Load Runner?
Which component in LR would be used to run the SQL Queries?
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 |
what is think time when u will use it?
What are the parameters in Load Runner?
What is the purpose of running the scenario?
Hi Guys, Is it possible to merge and compare graphs from different scenarios in load runnner ?
In a web application transaction response time comprises of some sub times like time from web browser to web server thn to application server and then time taken to get response from the database and back to the web browser following the same path.How to get these sub times distinctly in LR analysis?
Hi I want to learn Performance testing using load runner..Can anyone suggest me which is the best institute for load runner in bangalore??
Where are automatic correlation options set?
How you set maximum number of vuser that a host can run?
Does the Tool generates think time for the standard value defined in script with respect to server response when we use option use random think time 50 - 150%. or will tool simply calculates value randomly for the standard think time defined in script.
what is loadrunner?
What is running virtual user graph?
Which is the best institute for LOAD RUNNER in HYD? what is the market for LR present?