SQL Studio Objects

You can store SQL statements and drafts of database tables as SQL Studio objects in the database on locally in the Local Folder subdirectory. This means that you can use the objects at a later date.

Creating SQL Studio Objects

·         To create a new folder for SQL Studio objects in the database using the Catalog Manager, choose Catalog Manager ® New ® Folder.

·         To create SQL statements and store them as SQL Studio objects, use the SQL dialog, the Form dialog or the Visual Query dialog.

·         To store drafts of database tables as SQL Studio objects, create the table definition with the Catalog Manager.

You can enter the path for the Local Folder in the user profile settings.

Editing and Executing SQL Studio Objects

·         To edit a stored SQL Studio object, select the object and choose Catalog Manager  ® Open Object Definition.

·         To use a stored SQL Studio object in dialogs or a table definition, select the object. Choose Catalog Manager ® Send Object To and then the relevant dialog type.

·         To execute the SQL statements of a stored SQL Studio object directly, select the object and choose Catalog Manager  ® Execute. The system displays the result table in a separate window. If an error occurred, an error message is displayed in the status window of the SQL Studio. Depending on your settings, additional information such as the time it took to execute your SQL statements is also displayed there.

Renaming and Deleting SQL Studio Objects

·         To rename a stored SQL Studio object, select the object and choose Catalog Manager  ® Rename Object.

·         To edit a stored SQL Studio object, select the object and choose Catalog Manager  ® Drop Object.