SQL statements saved in the SQL Repository can be copied to the editable pane in other modules.
To copy SQL from the SQL Repository
-
From an editable pane in a module other than the SQL Repository, select File | Open SQL from SQL Repository.
-
Navigate through the tree structure and select the SQL statement.
-
Click Open.