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...>.
You see the following options in the dialog box:
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.
Select to import the SQL statement from an SQL file.
Select to export the SQL statement to an SQL file.
Select to view information about the dialog box.
The toolbar provides the following commands that facilitate the process of composing the SQL statement.
Select to cut the specified text in the text panel.
Select to copy the specified text in the text panel.
Select to paste the text that you previously cut or copied in the text panel.
Select to delete the specified text from the text panel.
Select to undo an action.
Select to cancel undoing an action.
Select to search for text in the text panel, and replace the found text with different text.
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.
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.