Background documentationSQL Editor Locate this document in the navigation structure

 

In the SQL Editor, you can enter, execute, and save SQL statements.

More information: Entering and Executing SQL Statements

The following rules apply:

  • You can write SQL syntax elements in either upper or lower case.

  • You can add any number of spaces and line breaks.

  • To force the system to take the case into account for database object identifiers (such as table names) and values in the form of literals, enter the identifier between single quotation marks: '<identifier>'.

  • 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.

If you press the key combination CTRL+Space after a word in the SQL editor, a list is displayed containing default values for this word. You must have already defined a corresponding template for this word. More information: Configuring Database Studio, Templates section.

SQL Editor: SQL Tab Page, Context Menu

Command

Description

Load

Open a saved SQL statement from a repository or file

Save

Save an SQL statement in a repository or file

Save As ...

Save an SQL statement under a different name

Explain SQL

Execute EXPLAIN statement for the SQL statement

The system displays the result of the EXPLAIN statement in the Explain view.

See: SQL Optimizer, Analyzing Search Strategies Using the EXPLAIN Statement

Execute SQL

The system executes the SQL statement.

  • If you enter multiple SQL statements separated by comment characters, the system executes all the entered SQL statements.

  • If you selected an SQL statement in the SQL editor, the system executes only the selected SQL statement.

Prepare Statement

Testing Prepared Statements

Choose Connection

Select connection to database:

  • Landscape

  • Database computer

  • Database name

  • User name

Clear

Clear input field

Format

Format input

SQL Editor: Result Tab Page, Context Menu

Command

Description

Go to Row ...

Go to row ...

Export Cell to ...

Export cell to ...

Export Result ...

Export result to a file

Filters

Define filters for columns

Edit

Edit a data record

In the status window, the system displays messages regarding SQL statement execution.

As AUTOCOMMIT mode, SQL mode, and isolation level, the system uses the values that you specified when you configured Database Studio. More information: Configuring Database Studio

To use other settings in the SQL editor that is currently open, change the setting on the Properties tab page (if this tab page is not open, choose   Window   Show View   Properties  ):

AUTOCOMMIT Mode

ON

The database system performs all the necessary COMMIT actions automatically.

OFF

You have to enter COMMIT commands explicitly.

SQL Modes

Name

Description

INTERNAL

SAP MaxDB SQL definition

ORACLE

ORACLE 7 SQL definition

For more information about the isolation level: Concepts of the Database System, Isolation Level