User Guide

SAP AG November 2002
If you do not have a Windows operating system, you can only use Web SQL to send requests
to the database instance.
Web SQL provides you with basically the same functionality as the SQL Studio [Page
150].
Operation depends on the Web-based application.
See also:
Architecture of the SAP DB Web Tools [Page
57]
Prerequisites
Check if the database instance is started.
Call
Enter the following address in the browser:
http://<web_server>:<port>/websql
See Web Tools Installation Guide: SAP DB 7.4 Section Using the SAP DB Web Tools [See
SAP DB Library]
Enter the name of the database computer, the name of the database instance, the user
name, and the user password.
Set-up of the Web SQL
Header
The header contains a link for logging off, among other things.
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.
User Manual: SAP DB 155