Working with the Database Checkpoint Wizard - WinRunner

The wizard opens whenever you create a custom database checkpoint and whenever you work with Data Junction. You can also use an SQL statement to create a database checkpoint. When working with SQL statements, create a custom database check and choose the ODBC (Microsoft Query) option.

You can work in either ODBC/Microsoft Query mode or Data Junction mode. Depending on the last tool used, a screen opens for either ODBC (Microsoft Query) or Data Junctio. You can change from one mode to another in the first wizard screen.

The Database Checkpoint wizard enables you to:

  • switch between ODBC (Microsoft Query) mode and Data Junction mode
  • specify an SQL statement without using Microsoft Query
  • use existing queries and conversions in your database checkpoint

ODBC (Microsoft Query) Screens

There are three screens in the Database Checkpoint wizard for working with ODBC (Microsoft Query). These screens enable you to:

  • set general options:
  • switch to Data Junction mode
  • choose to create a new query, use an existing one, or specify an SQL statement
  • limit the number of rows in the query
  • display an instruction screen
  • select an existing source query file
  • specify an SQL statement

Setting ODBC (Microsoft Query) Options

The following screen opens if you are creating a custom database checkpoint or working in ODBC mode.

Setting ODBC (Microsoft Query) Options
You can choose from the following options:

  • Create new query: Opens Microsoft Query, enabling you to create a new ODBC *.sql query file with the name specified below. Once you finish defining your query:
  • If you are creating a default database checkpoint, a db_check statement is inserted into your test script.
  • If you are creating a custom database checkpoint, the Check Database dialog box opens. For information on the Check Database dialog box, see “Creating a Custom Check on a Database”
  • Copy existing query: Opens the Select source query file screen in the wizard, which enables you to copy an existing ODBC query from another query file. For additional information, see “Selecting a Source Query File”
  • Specify SQL statement: Opens the Specify SQL statement screen in the wizard, which enables you to specify the connection string and an SQL statement. For additional information, see “Specifying an SQL Statement”
  • New query file: Displays the default name of the new *.sqlquery file for this database checkpoint. You can use the browse button to browse for a different *.sql query file.
  • Maximum number of rows: Select this check box and enter the maximum number of database rows to check. If this check box is cleared, there is no maximum. Note that this option adds an additional parameter to your db_check statement.
  • Show me how to use Microsoft Query: Displays an instruction screen.

Selecting a Source Query File

The following screen opens if you chose to use an existing query file in this database checkpoint.

Selecting a Source Query File
Enter the pathname of the query file or use the Browse button to locate it. Once a query file is selected, you can use the View button to open the file for viewing.

  • If you are creating a default database checkpoint, a db_check statement is inserted into your test script.
  • If you are creating a custom database checkpoint, the Check Database dialog box opens. For information on the Check Database dialog box, see “Creating a Custom Check on a Database”

Specifying an SQL Statement

The following screen opens if you chose to specify an SQL statement to use in this database checkpoint.

Specifying an SQL Statement
In this screen you must specify the connection string and the SQL statement:

  • Connection String: Enter the connection string, or click Create to open the ODBC Select Data Source dialog box, in which you can select a *.dsn file, which inserts the connection string in the box.
  • SQL: Enter the SQL statement.

When you are done:

  • If you are creating a default database checkpoint, a db_check statement is inserted into your test script.
  • If you are creating a custom database checkpoint, the Check Database dialog box opens. For information on the Check Database dialog box, see “Creating a Custom Check on a Database”

Data Junction Screens in the Database Checkpoint Wizard
There are two screens in the Database Checkpoint wizard for working with Data Junction. These screens enable you to:

  • set general options:
  • switch to ODBC (Microsoft Query) mode
  • choose to create a new conversion or use an existing one
  • display an instruction screen
  • specify the conversion file

Setting Data Junction Options

The following screen opens if you last worked with Data Junction or if you are creating a default database checkpoint for the first time when only Data Junction is installed:

Setting Data Junction Options
You can choose from the following options:

  • Create new conversion: Opens Data Junction and enables you to create a new conversion file. For additional information, see “Creating a Conversion File in Data Junction”. Once you have created a conversion file, the Database Checkpoint wizard screen reopens to enable you to specify this file. For additional information, see “Selecting a Data Junction Conversion File”.
  • Use existing conversion: Opens the Select conversion file screen in the wizard, which enables you to specify an existing conversion file. For additional information, see “Selecting a Data Junction Conversion File”.
  • Show me how to use Data Junction (available only when Create new conversion is selected): Displays instructions for working with Data Junction.

Selecting a Data Junction Conversion File

The following wizard screen opens when you are working with Data Junction.

Selecting a Data Junction Conversion File
Enter the pathname of the conversion file or use the Browse button to locate it. Once a conversion file is selected, you can use the View button to open the file for viewing.

You can also choose from the following options:

  • Copy conversion to test folder: Copies the specified conversion file to the test folder.
  • Maximum number of rows: Select this check box and enter the maximum number of database rows to check. If this check box is cleared, there is no maximum.

When you are done:

  • If you are creating a default database checkpoint, a db_check statement is inserted into your test script.
  • If you are creating a custom database checkpoint, the Check Database dialog box opens. For information on the Check Database dialog box, see “Creating a Custom Check on a Database”

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

WinRunner Topics