Entering content frame

Procedure documentation Executing a Database Statement Locate the document in its SAP Library structure

Use

You transfer the specified administration command or SQL statement to the database instance.

When you enter a SELECT statement, the system displays the results. The system outputs an OK message for other statements.

For more information about SQL statements, see:

Reference Manual

SQL Tutorial

Prerequisites

You have the server authorization AccessAdmin or AccessSQL.

You have opened a database session. (See: Opening a Database Session)

Syntax

db_execute <statement>

Reply

After executing an administration command, the system displays an OK message, or the specific reply for the administration command.

If an error occurs, an error message number is displayed.

See also:: Messages

After an SQL statement has been successfully executed, the following is displayed:

OK<NL>
END|CONTINUE)<NL>
<record><NL>
<record><NL>

The fields in an reply record are separated by semicolons.

Character strings are displayed in single quotation marks.

END

Result set output complete

Continue

More result data available

 

In the event of errors, see Reply Format.

 

Leaving content frame