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
- 20208 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 |
What are the differences between 9.1 and 9.5?
What is a correlation? Explain the difference between automatic correlation and manual correlation?
Diff btn silk Performer& Loadrunner?
What is a correlation?
If a load test has to run for 4 hours with 2,000 users, and the average iteration completes in 10 minutes, how many transactions will run per minute? can any give the calculation please.
pls suggest me a good institute for loadrunner in hyderabad also what about a practice project?
How to create a scenario?
What are the four selection methods when choosing data from a data file?
What is the benefit of running a vuser script as a thread?
In what situation would u want to parameterize a text verification check ?
What is transaction per second graph(pass)?
For what purpose, user will be using ‘continue on’ error?
WinRunner 
