SQL Repository Window
SQL Repository Window
The SQL Repository window displays the information about the SQL statements that are saved in the SQL Repository. It is divided into three panes.
SQL Listing (Left pane)
Displays a tree diagram of the SQL statements and the folders they are stored in.
SQL Listing Details (Top right pane)
Displays detailed information about the folder, the SQL statement, or the folder with its contents depending on which item in the tree in the left pane is selected.
SQL Information Details (Bottom right pane)
The detailed information about the SQL statement is displayed in the button pages. The buttons for displaying specific information are found at the top of this pane.
Properties button
Displays general information, the SQL name, where the SQL statement was copied from, the logon connection, and database and other settings.
SQL Information button
Displays SQL Information pane where you can select to display the SQL text, the access plan, SQL classification, and DDL for any temporary tables used in the SQL statement.