Creating SQL Statements 

Use

In the SQL dialog, you can create and save SQL statements in a number of different modes.

Procedure

...

In the user settings, select the required SQL mode and isolation level*.

Select the required commit mode.

If you have the user attribute EXCLUSIVE*, you can only select the mode Auto Commit: ON.

-         Choose View ® SQL Dialog for the mode Auto Commit: ON

-         Choose View ®SQL Dialog Auto Commit Off for the mode Auto Commit: OFF.

The system opens a window for the SQL dialog.

Enter your SQL statements.

You can add SQL statements that were already executed during the current database session. Choose SQL Dialog ® Recent Statements. Select the required statement, and choose Get.

To comment out a row, use // or –– at the start of the row.

To separate several SQL statements from one another, enter a commented-out separator line.

To scroll through the statement history of the database session, choose SQL Dialog ® Previous Statement or Direct SQL  ® Next Statement

You can set parameters for SQL statements.

To use or edit your statements again later, save them as SQL Studio objects by choosing SQL Dialog   ®  Save As.

The  keyword list supports you in creating SQL statements.

*For an explanation of the terms “isolation level” and “SQL mode,” see the isolation level and SQL mode sections of the documentation The SAP DB Database System.

For an explanation of the user attributes, see the authorization section of the Reference Manual: SAP DB.