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
- 21124 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
How is each step validated in the script?
What should be done to view parameter substitution in the execution log?
How can we edit the vuser script?
What are all the types of goals in goal-oriented scenario of load runner?
How to run a scenario?
How do you enable text and image checks in vugen?
What are the types of checkpoints is available in loadrunner?
What is vuser-init section?
When loadrunner is used?
Explain the difference between automatic correlation and manual correlation?
what are the risks you faced with loadrunner
How you set maximum number of vuser that a host can run?
What is the difference between web_reg_find and web_find?
How you enhance the basic script?
What are monitors?
