Chatta subito con l'assistenza
Chat con il supporto

SQL Optimizer for SAP ASE 3.8 - Installation Guide

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

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione