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
- 20166 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 |
How to upload media use loadrunner? I record the script but it fail because the top of document is invalidation.How to solve the problem?Which one know the answer please tell me. Thanks!
I want step by step guidelines on loadrunner.i think it will be a great.please can any one help me.
Throughput ?
What do you mean by remote command launcher(rcl)?
What is report header and what are the information contains?
How many types of scripts generated in LoadRunner?What are they?
You test the scalability testing by apllying load more than the designed number of users. If you dont know the designed number of users then how you do the scalability test?
Why do you create parameters?
How many values can be generating in script we can Parameterize even it is in one scenario 1000Parameterization values are there it is correct to Parameterized?or not?
Is there any special setting required in internet explorer or laod runner VUGen to prepare script in load runner using seibel web protocol. is it same like web-Http/Html?
what is the procedure to create test case in web performance load testing and how to download loadrunner and QTP
To open gmail home page how much transactions has taken to open, how to calculate the time?
WinRunner 
