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
- 21205 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 is parameterizion?
What are the types of checkpoints is available in loadrunner?
When the loadrunner controller open the winrunner file then what is the location of the winner configuration file?
What is action section?
What is loadrunner controller?
What are different types of vuser logs which can be used while scripting and execution?
What is x-windows?
What are the section contain by the vugen while creating a vuser script?
when i run start senario for different process it always completed at elapsed time 6.32 sec. i don't understand why it happens.. can we set elapsed time ? plz answer.... pratik196@gmail.com
What are the three sections of a vuser script and what is the purpose of each one?
What is the basic credentials should be provided while recording SAP-GUI?
What are the different components of loadrunner?
What in percentile graph?
How vugen create a vuser script?
What is host?
