Chatee ahora con Soporte
Chat con el soporte

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

Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.

Seleccionar calificación