立即与支持人员聊天
与支持团队交流

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

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级