Enable SQL Comments form

Administration DBA Top SQL Top SQL view Actions Enable SQL Comments Enable SQL Comments form

The Enable SQL Comments form allows you to display the developer comment and the default system comment for the SQL statement on the Top SQL view.

• The developer comment displays any comment entered by the N4 developer, limited to 100 characters.

• The default comment displays the user ID, session type, host name, the caller's Java class, and the line of the code that executed the SQL statement. 

This feature displays comments globally at the operator level, not per yard or facility. You can select whether to enable this feature for only your current node, or for all nodes.

There are two ways to view the comments:

• Add the Comment column in the Top SQL view.

• Double-click on the SQL statement row in the Top SQL view. A new window appears with the comment included with the SQL statement.

To turn on SQL comments:

1. From the Top SQL view, choose Actions Enable SQL Comments.

2. Select whether to apply the change for the local node only or for all nodes.

3. Click OK.