Managing your queries

You can view a list of your last run queries, search for a query, modify or delete a query from the list.

To manage your queries by using the tool, complete the following steps:

1. Start the DB Query Client by using the following URL:

   https://<hostname:port>/smcfs/yfshttpdbi/sterlingdbqueryclient.jsp

2. Enter the User ID and Password. The user authentication is valid until the current session expires or until the current session is closed. If the current browser session expires, you can enter your login credentials and run queries on the same page.
3. Find your queries in one of the following ways:
   • Click Last run queries to view all the queries that you ran previously. The last 100 previously run queries are saved and 10 queries are displayed per page.
   • In the Search for queries field, enter appropriate terms such as query keywords or table names to find your query. For example, search terms can be YFS_USER, SELECT. Alternatively, you can scroll the list and click Next or Previous to find your query.
4. Manage your queries in the following ways:
   • If you want to modify a previously run query, click Edit, the query is loaded in the Enter SQL query box. Modify it as required and run the query.
   • If you do not want to reuse a last run query, click Delete to remove it from the list of last run queries.