Chat now with support
Chat with 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

Modify the Data

SQL Worksheet > Modify the Data

Modify Data

In the SQL Worksheet, you can modify the data from a table. The Edit button is not enabled until text is highlighted in the Editor pane.

To modify the data in a table

  1. Highlight a table from the text in the Editor pane in the SQL Worksheet window.

  2. Click image\B_Edit.gif.

  3. Use the Edit button bar at the bottom of the pane to modify the data.

Note: If you create a table and enter data in the SQL Worksheet, you must synchronize the data dictionary by selecting Database | Synchronize Data Dictionary before you can use the Edit command or Edit button to modify the data.


Related Topic

New Database Session

SQL Worksheet > New Database Session

The SQL Worksheet uses a different database session to execute the SQL and Transact SQL from the one that was created when you initially logged on. It is important to understand how using a different session affects your work in other modules.

Temporary Tables

Temporary tables created in the SQL Worksheet are not available throughout the rest of the modules. For example, if you create #temp1 in the SQL Worksheet, you are not able to use that temporary table in SQL Optimizer. Also, if you create a temporary table in the User-Defined Temp Table window, you will not be able to use it in the SQL Worksheet.

Changes to the Data Dictionary

Each time you logon, information from the data dictionary is loaded into the memory of the local PC. If you make changes to the data dictionary in the SQL Worksheet, these changes are not reflected in the information that was initially stored on the local PC. For example, if you create a new table in the SQL Worksheet and then optimize a SQL statement that uses the new table, you will get a message saying that the table does not exist. This is because the data dictionary on the local PC was not updated.

To update the data dictionary

Select Database | Synchronize Data Dictionary.


Related Topic

Command List

SQL Worksheet > Command List

The Command List stores each command that is successfully executed in a drop-down field at the top of the SQL Worksheet window. The following functions are available from the right-click menu in the Command List.

Save Commands

Brings up the Save Commands window so you can select which commands you would like saved to a file.

Load Commands

Brings up the Open Commands window so you can select which commands to load in the Command List from a list that you saved previously.

Clear Commands

Brings up the Clear Commands window so you can select which commands you would like remove from the Command List.



Related Topic


SQL Worksheet > Bookmarks

Bookmarks can be set to quickly return to a place in your code. To set a bookmark, right-click, select Toggle Bookmark or select Set | Toggle Bookmark and then pick a bookmark number between 0 and 9. The bookmark number displays in a field in the gutter in place of the line number.

To move the cursor to a bookmark

  1. Right-click and select Goto Bookmark.

  2. Select your bookmark number.

To move to the next or previous bookmark

Select Set | Previous/Next Bookmark.


Related Topic

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating