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
- 21304 Views
- I also Faced
- E-Mail Answers
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
What do you mean by initialization of quota?
What kind of problem can we face regarding hardware, software, network and memory bottleneck during the performance test?
What is the difference between lr_error_message and lr_debug _message?
How is automated correlation configured?
What in percentile graph?
What is the load runner testing process?
What is loadrunner controller?
Where are automatic correlation options set?
How to schedule a scenario?
When the rendezvous point is insert?
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
What are the four selection methods when choosing data from a data file?
How do you decide the number of load generator machine required to run a test?
What is manual correlation?
What is loadrunner agent?
