Imported SQL Editor Dialog Box

You can use the Imported SQL Editor dialog box to create and edit imported SQLs in a catalog. This topic describes the options in the dialog box.

Designer displays the Imported SQL Editor dialog box when you do one of the following:

In the Catalog Manager, right-click a JDBC connection node and select Add SQL from the shortcut menu.
In the Catalog Manager, right-click an imported SQL under the Imported SQLs node and select Update from the shortcut menu.
In the dialog box where an imported SQL list is available, expand the Imported SQLs node in a catalog data source that contains only one JDBC connection and select <Add SQL...>.

Imported SQL Editor

Designer displays these options:

SQL Name

Specify the name of the imported SQL when you are adding it to the catalog.

From DB Catalog

Specify the catalog in the database which contains the tables/views/synonyms you want to use in the imported SQL.

Save & Exit

Select to save the SQL statement with the specified name as an imported SQL into the catalog and exit the editor if there are no errors in the SQL statement; otherwise, Designer prompts a warning message showing the errors. You need to correct all the errors to save the SQL statement.

Import SQL

Select to import the SQL statement from an SQL file.

Export SQL

Select to export the SQL statement to an SQL file.

Help

Select to view information about the dialog box.

Text panel

You can write or edit your SQL statement in this panel. You can type the statement directly, paste it from another text editor, or import it from an SQL file.

The toolbar in this panel provides the following buttons that facilitate the process of composing the SQL statement.

Cut
Select to cut the specified text in the text panel.
Copy
Select to copy the specified text in the text panel.
Paste
Select to paste the text that you previously cut or copied in the text panel.
Delete
Select to delete the specified text from the text panel.
Undo
Select to undo an action.
Redo
Select to cancel undoing an action.
Search
Select to search for text in the text panel, and replace the found text with different text.
Check
Select to check whether there are errors in the SQL statement.
Add Bookmark
Select to add a bookmark to a line.
Go to Previous Bookmark
Select to go to the previous bookmark.
Go to Next Bookmark
Select to go to the next bookmark.
Clear All Bookmarks
Select to remove all the bookmarks.

Previous Topic Next Topic