Chat now with support
Chat mit Support

SQL Optimizer for SAP ASE 3.8 - Release Notes

Save SQL to SQL Repository

If you are using this function from the SQL Scanner, you can send multiple SQL statements to the SQL Repository. If you are using this function from the other modules, you can send one SQL statement to the SQL Repository.

To save multiple SQL statements to the SQL Repository module

  1. In the SQL Scanner, select the Job which contains the SQL statements. In the SQL Inspector, click in the SQL Text pane.

  2. Click Save SQL to SQL Repository image\B_SaveSQLtoSQLRepository.gif.

  3. Select the location in which to save the SQL statements and click OK.

To save a SQL statement to the SQL Repository module

  1. In the modules with a SQL Text window, select a SQL statement.

  2. Click Save SQL to SQL Repository image\B_SaveSQLtoSQLRepository.gif.

  3. Select the location in which to save the SQL statements and click OK.

Only valid SQL statements are added to the SQL Repository.

Note: The SQL Repository only supports a single SELECT, INSERT, UPDATE or DELETE SQL statement.

 

Related Topic

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen