User Guide

SAP AG November 2002
Session
See Database session [Page 135]
Single Backup Medium
You have the option of defining single backup media [Page 127]. The database system
performs its backup [Page 126] to this medium. Where the capacity of the backup medium is
too small for the backup that has started, the system asks for a succeeding medium.
SQL Locks
See Lock [Page 140]
SQL Mode
The SAP DB database system is capable of executing database applications that are written
in accordance with one of the following definitions:
• INTERNAL: internal database system definition
•
• ANSI: ANSI standard in accordance with ANSI X3.135-1992, entry SQL
• DB2: Definition DB2 Version 4
ORACLE: Definition ORACLE7
When you log on to the database system, you can select one of the definitions listed above
(see CONNECT Statement [See SAP DB Library]
). The default SQL mode is INTERNAL.
The database system is capable of checking new applications to ascertain whether they
correspond to one of the above definitions. In particular, this means that no extensions that go
beyond the selected definition are regarded as correct.
Support of other SQL modes is restricted with regard to DDL statements.
SQL Mode ORACLE: SAP DB 7.4 [See SAP DB Library]
SQL Studio
The SQL Studio (SQL Studio: Introduction [Page 65]) has a user-friendly, graphical user
interface.
The SQL Studio in the form described here can only be used on Windows operating systems.
If you want to use the functionality of the SQL Studio on other operating system platforms,
you must use Web SQL [Page 154].
Prerequisite
Check if the database instance is started.
User Manual: SAP DB 150