User Guide

SAP AG November 2002
Stored SQL Studio Objects
Web SQL the same data as SQL Studio. The folders and SQL Studio objects stored in SQL
Studio are visible in Web SQL. One exception is the SQL Studio 'Local Folder' for storing
local SQL Studio objects.
Objects
SQL Dialog objects can be read and written. In the case of the objects Form Dialog, Visual
Query and Result Tables, the underlying SQL statement is displayed, but the objects cannot
be changed. Web SQL can create, delete, move, and rename folders and SQL Dialog objects
itself.
SQL Dialog window
You can enter and execute SQL statements in this window. You can display SQL statements
from all SQL Studio objects, and you can also store SQL Dialog objects. You can store newly
created SQL statements.
Additional functions
Before executing each SQL statement, you can set the AutoCommit mode, the SQL mode,
and the isolation level. You can display previously executed SQL statements using Previous
and Next. A button is available for clearing the SQL window. You can execute several SQL
statements. You must separate these from each other using a line with // or -- .
Result window
If SQL mode INTERNAL was selected for executing SQL statements, you can navigate
flexibly through the result set.
If SQL mode INTERNAL was selected for executing SQL statements, you can zoom the
column of data type LONG.
If one of the other SQL modes was selected for executing SQL statements, you can only
navigate forwards in the result table.
If several SQL statements were executed, you can access the results and the messages
relating to these SQL statements with a drop-down list.
Directory Structure of the Database for SAP
Systems
How the directories required for the SAP DB database system are distributed to the available
hard disks has a significant impact on the security and performance of your database system.
A good distribution of files on the hard disk must meet the following requirements:
• There must be enough free space to allow the database to expand
• The data must be stored securely
• The hardware must meet the performance requirements
Distribution of the SAP DB Directories on the Hard Disk [Page
68]
Conventions
Variables [Page
68]
User Manual: SAP DB 67