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

SQL Information and Functions > Modify Data

You can edit the data in the Database Explorer, the SQL Worksheet, the Run Result, and the Parameters windows. When the data is display, a button bar displays at the bottom of the pane when you can edit the data. This button bar offers functions to view, edit, insert and delete data.

image\ModifyDataButtonBar.gif

Navigate Data

To navigate through data you can either use the scroll bar or use the Navigator image\T_NaviagteButtonBar.gif buttons (First Record, Previous Record, Next Record, and Last Record). Depending on the amount of data, scrolling to the bottom of the page or executing the Last Record function may take a long time as all records are retrieved from the database.

Edit a Record

To edit the record's column, place the cursor on the record that you want to edit and click Edit Record image\B_EditRecord.gif. You can change the data in the grid. Press the tab key or use the mouse to move to the next column. Once you complete the modification, click Commitimage\B_EditCommit.gif or Rollback image\B_EditRollback.gif.

Insert a Record

To insert a new record, place the cursor on the record that you want the new record inserted before and click Insert Record image\B_EditInsert.gif. Enter data for each column, press the tab key or use the mouse to move to the next column. Once you have completed entering the data, click Commitimage\B_EditCommit.gif or Rollback image\B_EditRollback.gif.

Delete a Record

To delete a record, place the cursor on the record that you want to delete and click Delete Record image\B_EditDelele.gif. Click OK on the confirmation dialog to confirm that the record you want to delete is correct. The Delete Record is automatically committed on your database.

Refresh Data

To refresh the data, click Refresh image\B_EditRefresh.gif.

Note: Not all Views are updateable; a general rule is that any UPDATE, DELETE, or INSERT statement on a join view can be modified if only one underlying base table exists.

 

Related Topic

Copy Data from a Single Cell

SQL Information and Functions > Copy Data from a Single Cell

You can copy the data from a single cell into the windows clipboard from the Database Explorer, the SQL Worksheet, the Run Result, and the Parameters windows.

To copy data

  1. Highlight the cell with data.

  2. Right-click and select Copy.

 

Comments

SQL Information and Functions > Comments

The three most popular comment delimiters used within SQL statements are recognized as valid SQL syntax:

  • A single line comment using --
  • A single line comment using //
  • A block comment starting with /* and ending with */

Other comment delimiters are not accepted as valid SQL syntax. Due to the lack of uniform standards in the presentation of comments within source code, it is not practical to implement each and every commenting indicator.

 

Parameters

SQL Information and Functions > Parameters

Parameters, also called variables, can be embedded in a SQL statement without pre-defining the data type and value. All variable names are highlighted in red (by default) after the formatting. Variables with or without a "@" sign are recognized. When you optimize the SQL statement or retrieve the query plan, run time, the run result for a SQL statement that uses a parameter, you are prompted to enter the variables using the Parameters window.

Note: You can retrieve the query plan for a SQL statement that has a variable without the need to enter the data type or value by executing the Show Default Plan function from the SQL menu.

 

Related Topic

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen