Configuration Guide › Relational Database Management › How to Describe a Database in a Directory Configuration File › How to Modify Attribute Descriptions › Custom Operations › Operation Element

Operation Element

The Operation element defines a SQL statement which can execute a custom query or calls a stored procedure for creating, retrieving, modifying, or deleting an attribute. Operation element is a subelement of the IMSManagedObjectAttr element, as shown in the following example:

<ImsManagedObjectAttr physicalname="tblUsers.id" displayname="User Internal ID" description="User Internal ID" valuetype="Number" required="false" multivalued="false" maxlength="0" hidden="false" permission="READONLY">
  <Operation name="GetDb" value="select @@identity" />

Operation element parameters are as follows:

name

Specifies a predefined name for an operation. The valid operations are as follows:

• Create
• Get
• Set
• Delete
• GetDB

  The GetDB operation retrieves a unique identifier from the database during a Create task, when the unique identifier is generated through the database or from a stored procedure.

value

Defines the SQL statement or stored procedure to execute. The valid values are as follows:

• INSERT
• SELECT
• UPDATE
• DELETE
• CALL (for stored procedures)

Note: The parameters are optional unless otherwise specified.

The Operation element can contain one or more Parameter elements.