InfoCenter

Database statements

Click Statements to manage SQL or File Upload statements previously saved by a group or user. An administrator can copy a statement to another group or user, rename a statement, or delete a statement.


To administer saved SQL or File Upload statements for a group or user:
  1. Click Users/Group in the Host On-Demand Administration window.
  2. Right-click the group or user and click Database > Statements.

All saved queries for the selected group or user display. If there are no saved queries, an informational message appears.

The administrator can now:


Copy a statement

An administrator can copy saved SQL or File Upload statements from a user or group to another user or group.

When a saved statement is copied to a group, all members of the group have access to the saved statement. Users can run or open the saved statement, if allowed. Users can also save changes to the modified query; however, the changes are saved only to the user's copy of the saved statement, not to the statement saved at the group level.

To copy a saved SQL or File Upload statement:

  1. From the Administer Statements tab, select the statement you want to copy.
  2. From the Groups and Users tab, select the destination group or user.
  3. Click Copy to >>.
  4. Modify the Statement Name, if desired.
  5. Click OK.

Rename a statement

An Administrator can rename a saved SQL or File Upload statement. After a statement is renamed, the original statement name is no longer valid.

To rename a saved SQL or File Upload statement:


  1. From the Administer Statements window, select the statement you want to rename.
  2. Click Rename.
  3. Modify the statement name.
  4. Click OK.

Delete a statement

An administrator can delete a saved SQL or File Upload statement. After a statement is deleted, the original statement is no longer accessible. The delete action is final.

To delete a saved SQL or File Upload statement:


  1. From the Administer Statements window, select the statement you want to delete.
  2. Click Delete.
  3. Click Yes to confirm the delete operation.

Related topics