Tchater maintenant avec le support
Tchattez avec un ingénieur du support

SQL Optimizer for SAP ASE 3.8 - User Guide

Introduction Tutorials Preferences Editor Functions SQL Information and Functions Performance Monitor SQL Inspector SQL Collector for Monitor Server SQL Scanner Index Advisor SQL Optimizer
SQL Optimizer Overview Optimization Engine Common Coding Errors in SQL Statements What Function Should l Use to Retrieve the Run Time? Unsatisfactory Performance Results SQL Optimizer Functions SQL Editor Optimized SQL Activity Log
SQL Worksheet SQL Formatter Database Explorer Code Finder Object Extractor SQL Repository Index Impact Analyzer Index Usage Analyzer Configuration Analyzer Migration Analyzer Abstract Plan Manager User-Defined Temp Tables SQL History Legal Information

SQL Worksheet Overview

SQL Worksheet > SQL Worksheet Overview

The SQL Worksheet allows you to enter and execute multiple SQL statements, database objects, Transact SQL scripts. Supported SQL statements include DML and DDL commands. Local temporary table operations are allowed.

 

Related Topics

SQL Worksheet Window

SQL Worksheet > SQL Worksheet Window

The SQL Worksheet window consists of the following: Command List, Object Explorer, Editor Pane, Information Pane, and Status Bar.

Command List

Each time a command is successfully executed, the command is saved in the Command List drop-down field at the top of the window.

Object Explorer

Provides information on database objects. It is possible to drag drop object text and name to the Editor Pane.

Editor Pane

The top right pane is the Editor pane which is used as a work area to create, modify, and execute SQL statements or Transact SQL commands.

Information Pane

The bottom pane has 2 tabs: Message Log and Resultn.

Message Log

Displays information, alert and error messages from each execute. This includes the date and time, Adaptive Server messages, and whether the execution was successful or not. This information is accumulative.

To clear the Message Log information

Right-click and select Clear All.

Result

Displays the result set after executing the command in the Editor pane. There can be multiple Result tabs, one for each result set from the code that was executed.

Status Bar

image\W_Sy_SW_StatusBar.gif

Progress Bar

Displays execution time while code is executing.

Num, Insert, Caps, Scroll

Specifies the state of the key functions for the Number Lock, Insert Mode, Caps Lock, and Scroll Lock.

Modified

Specifies that a modification was made to the text in the Editor pane.

n:n

Specifies the line and column position of the cursor.

nnn bytes

Specifies the number of bytes of text in the Editor pane.

SPID

Specifies the SPID for the database session used by the SQL Worksheet. The session is not connect until the first time you execute a command.

 

Related Topics

Execute SQL or Transact SQL

SQL Worksheet > Execute SQL or Transact SQL

To open the SQL Worksheet window

Click image\B_SQLWorksheet.gif.

You can enter text into the SQL Worksheet by

  • Copying from the Database Explorer, the SQL Scanner, or the SQL Optimizer. (Click image\B_CopyToSQLWorksheet.gif)

  • Typing the text.

  • Opening a file. (File | Open).

  • Opening a file or database object found through the Code Finder. (Right-click and select Open in SQL Worksheet)

To execute your SQL statement or Transact SQL code

Click image\B_Execute.gif.

To abort the execution of SQL statement or Transact SQL code

Click image\B_AbortExecute.gif.

Note: In Adaptive Server when you complete a transaction, it is committed to the database.

 

Related Topic

Retrieve Description of Tables and Views

SQL Worksheet > Retrieve Description of Tables and Views

You can retrieve the description for a table or view which gives you the column definitions, data type, and length of the column. This function is not available until text is highlighted in the Editor pane.

To retrieve the table description

  1. In the Editor pane of the SQL Worksheet window, highlight a table or view name.

  2. Click image\B_sp_help.gif.

Note: The information is retrieved from the database using the sp_help procedure. Whatever text you highlight is sent to Adaptive Server as the parameter to sp_help. If you highlight an entire SQL statement, Adaptive Server executes sp_help without a parameter and executes the SQL statement. The SQL Worksheet then displays the result of both executions.

 

Related Topic

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation