Creating and Saving Query Files

You can create a query (.qry) file to add an SQL statement operation in the Database Service editor. A query file contains a SQL statement that you create manually, or through Visual SQL.

To create a query file:

  1. From the main menu bar, select File|New|Other.

    The Select a wizard dialog appears.

  2. Select Sybase|Query, and click Next.

    The Create Query File dialog appears.

  3. In the Create Query File dialog, specify:

    • A name for the query.

    • An available database connection profile in the Profile list.

  4. Click Advanced to link to a file in the file system.

  5. Click Finish to create the query.

    A list of database tables appears in the SQL Query editor.

Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com