Previous Topic: Create a QueryNext Topic: Save a Query


Open a Query

You can work with queries you saved to a *.qry file in a previous session, or you can optionally use a *.sql, or Microsoft SQL Server Query file.

To open a query

  1. Click Query Tool on the Tools menu.

    The Query Tool opens.

  2. Click the Open Query ODBC_Open Query Button icon on the toolbar.

    The Open dialog opens.

  3. Select a *.qry or *.sql file and click open.

    The query text opens the Query box and is ready for execution.

Note: Before you can execute a query you must be connected to ERwin ODBC or to a database.

More information:

Execute a Query Against ERwin ODBC

Execute a Query Against a Database

Restrict Row Count in Query Results