Background documentationScreen Areas in Web SQL Studio Locate this document in the navigation structure

 

You come to the main screen after you have logged on to the database using Web SQL Studio.

This graphic is explained in the accompanying text.

Main Screen

Screen Areas of the Main Screen

No.

Area Name

Description

1

Header

  • Information about the current database session: Name of the database, name of the database user who is logged on

  • Logoff button

2

Repositories

WebDAV repositories (if available)

See Opening WebDAV Repositories

3

Result

Result window

  • Result list (if you execute multiple SQL statements simultaneously, the list contains multiple entries)

  • Option of scrolling through the result table

  • Number of displayed result rows

  • Result table of the SQL statements

    Note Note

    To display values completely in LOB columns, click the respective value. This brings you to the zoom screen (see below).

    End of the note.

4

Footer

  • Version of the database

  • Additional Information about the current database session: AUTOCOMMIT mode, SQL mode, isolation level

5

Stored Statements

Saved SQL statements

See Saving SQL Statements

6

SQL Entry

Input area for SQL statements

Buttons:

  • Execute (SQL statement)

  • Clear (delete entries)

  • History Back (scroll back in the history of executed SQL statements)

  • History Forward (scroll forward in the history of executed SQL statements)

  • Save (SQL statement)

    See Executing SQL Statements

Zoom screen

The zoom screen opens when you click a value in a LOB column.

This graphic is explained in the accompanying text.

Zoom Screen

Screen Areas of the Zoom Screen

Screen Areas of the Zoom Screen

No.

Name

Description

1

Zoom

Zoom screen

  • Buttons and fields:

    • Back to Result (back to main screen)

    • Offset (position from which the LOB value is displayed)

    • Refresh (apply offset)

    • Representation (form in which the LOB value is displayed): text, decimal, hex

    • Truncation (truncation of value to a size in KB)