Open SQL

Open SQL is a set of ABAP/4 commands which perform operations on database tables. The results of these operations and associated error messages are independent of the database system used. Open SQL thus offers you unified SQL syntax and semantics for different database systems (see Portability). An ABAP/4 program which uses these commands can be run on database systems supported by SAP without modification.

Command set

The Open SQL command set includes the following commands:

• SELECT

• INSERT

• UPDATE

• MODIFY

• DELETE

• OPEN CURSOR

• FETCH

• CLOSE CURSOR

• COMMIT WORK

• ROLLBACK WORK
  
  

Note

To execute an Open SQL command, it is essential that

1. The addressed database system is supported by SAP
2. The database table is defined in the ABAP/4 Dictionary

For further information please refer to Open SQL in the SAP Library.