To change the name or description of an existing statement, follow these steps. You can also use this procedure to provide a description for an existing statement if you did not already do so in the New SQL Statement dialog box, as described in Section Creating a New SQL Statement.

1.Open the SAM that includes this statement as described in Opening an Existing SAM.

2.Open the SQL statement as described in Opening an Existing SQL Statement.
The syntax of the SQL statement appears in the SQL Editor window.

3.Select SQL Statement Ø Description.
The SQL Statement Description dialog box appears, as shown below. It displays the name and, if one exists, description of this statement specified in the New Statement dialog box.

SQL Statement Description Dialog Box

1.If desired, type a new, unique name for the statement in the Name entry field.
If you do not specify a name that is unique in the current SAM a message box appears informing you that the name you specified already exists and instructing you to rename the statement.

2.If desired, type a description for the statement in the Description field, or edit the existing description.
The description appears as a comment in the ESL code that DB/Assist generates for this statement.

3.Select the OK push button.
DB/Assist associates the new name and description with the SQL statement.