How to execute set of multiple SQL queries in Load Runner?
Which component in LR would be used to run the SQL Queries?
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 vugen script modified after recording?
How is each step validated in the script?
What is extended log?
How can you test the global servers with using loadrunner
What are the information crating for each host?
What do you mean by initialization of quota?
What would be your recommendation to improve performance measure?
What is a correlation?
What are different types of vuser logs which can be used while scripting and execution? What is the difference between these logs? When you disable logging?
How load runner interacts with the application?
How you develop the database vuser script?
What should be done to view parameter substitution in the execution log?
What is difference between manual scenario and goal oriented scenario?
How many types of vuser are available?
How you set maximum number of vuser that a host can run?