User Guide

SAP AG November 2002
If you use the SAP DB Loader CLI (LOADERCLI) to call the Loader, these must be
transferred in a command file [See SAP DB Library]
<command_file> (Option -b [See SAP
DB Library]).
SQL Studio: Introduction
The SQL Studio is a database tool [Page 136] that enables easy access to application data
[Page 125] and the database catalog [Page 131] of an SAP DB database instance.
You can create, execute, and manage any number of SQL statements. You can create,
display, or change database catalog objects.
Architecture
The client part of the SQL Studio creates a connection to the database instance [Page 132]
using the ODBC interface. The same functionality is offered for the SQL Studio regardless of
which client you use.
Server/Clients for SQL Studio
Server Client
Database Instance SQL Studio [Page 150]
Web SQL [Page
154]
See also:
SQL Studio Architecture [Page
56]
Architecture of the SAP DB Web Tools [Page 57]
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.
Call
You have the following options for calling the graphical user interface of the SQL Studio:
• Choose Start → Programs → SAP DB → SQL Studio. Log on to the desired database
instance.
• You can start SQL Studio from the command line. In this case, you can transfer options
[Page 66] to the SQLSTO program.
See also:
SQL Studio: SAP DB 7.3 [See SAP DB Library]
→ Starting SQL Studio [See SAP DB Library]
User Manual: SAP DB 65