Explain how to test a SQL Query in Winrunner
The following is the exact process:
1. Connect to the database by using –
db_connect( query1 DRIVER {drivername};SERVER server_name;UID uidname;PWD password;DBQ database_name );
2. Execute the query of the database by using -
db_excecute_query( write the required query that is to execute);Specify the appropriate condition
3. Disconnect the database connection by using - db_disconnect( query );
Using Output database checkpoints, SQL manual queries options must be selected. Here, the select query can be written.
