SQL Optimizer for SAP ASE 3.8 - Installation Guide

Add Database Objects (Add Jobs Wizard)

View Add Jobs Wizard - Add Database Objects Page

The SQL Scanner can scan all SQL statements within database objects. These include views, procedures, triggers, rules, defaults and tables. Use the Database Objects page on the Add Jobs wizard. The database objects can be selected by their object name, object type or user name.

Note: You must have privilege to access the system catalog table, syscomments, therefore the select on syscomments.text configuration parameter must be turned on. Also, your access to the specific database objects depends upon the database access privileges on your logon.

By clicking each branch name, the associated list of sub-items can be expanded or collapsed. You can add a database object to a Group by highlighting the name, object type or object name, followed by clicking , double-clicking the item, or dragging the item to the list on the right [Selected objects]. To include the objects dependencies select the corresponding checkbox from the list on the right [Selected objects].

Alternatively, you can click to open the Add Database Objects window. Select the database, user, and object type. Using the % wildcard, enter the filtering criteria. The filter is case sensitive, so you must match the upper or lowercase of the database object. Select the database objects and click OK to add the selected objects to the Add Jobs wizard. If a database object is already listed in the list on the right [Selected objects] of the Add Jobs wizard, it will not be entered again.

Note: By default, the scanning process uses the object’s database and the user who owns the object. You can change this to the current database and user on the Summary page of the Add Jobs wizard.

Related Topic

Add Jobs to SQL Scanner