Writing PSM

Entering PSM Statements

The users can write PSM statements directly in the Editor area. As with SQL Editor, the users can use functions such as Copy, Undo, Find/Replace, and Format through the Context Menu or shortcut keys.

In addition, the users can easily create PSM keywords, procedures, functions, etc. through the auto-complete function.

Template

The users can open the Template tab by right-clicking in the PSM Editor area and selecting the Context Menu > Template menu, or by using GNB's View > Template menu.

Clicking on a template item in the tree on the right side of the application screen will enter the template into the currently active Editor.

The users can easily create PSM sentences using the pre-made templates.

Template

Object List Window

The Object List WIndow is a feature that allows the users to check the list of objects that exist in a specific schema and enter the code of those objects in PSM Editor. The users can open the Object List Window through the PSM Editor Toolbar > Objects menu.

The following Object Types are supported.

• PROCEDURE

• FUNCTION

• PACKAGE

• PACKAGE BODY

• TYPE

• TYPE BODY

• TRIGGER

In the Object List WIndow, the users can view the list of objects that can be viewed based on the DB connection information of the called Editor. The DB connection information can be found at the bottom left of the Object List Window.

If the users select Schema, Object Type, and Object Name from the drop-down, they can preview the code of a specific Object through the CodePanel. After confirmation, click [OK] button to create a new PSM Editor window with the code of the selected Object.

Object List Window