Configuration Guide › Relational Database Management › How to Describe a Database in a Directory Configuration File › How to Modify Attribute Descriptions › Custom Operations › Parameter Element › Example: Custom Operations for the Business Number Attribute

Example: Custom Operations for the Business Number Attribute

In the following example, the Business Number attribute is generated by calling a stored procedure; it is not a physical attribute in the database.

<ImsManagedObjectAttr wellknown="%BUSINESS_NUMBER%"     displayname="Business Number" description="Business Number"     valuetype="String" required="false" multivalued="false"     maxlength="0">
<Operation name="Get" value="call sp_getbusinessnumber(?)">
    <Parameter name="%USER_ID%"/>
</Operation>
<Operation name="Set" value="call sp_setbusinessnumber(?,?)">
    <Parameter name="%USER_ID%"/>
    <Parameter name="%BUSINESS_NUMBER%"/>
</Operation>
<Operation name="Delete" value="call sp_deletebusinessnumber(?)">
    <Parameter name="%USER_ID%"/>
</Operation>

Note the following points:

• sp_getbusinessnumber, sp_setbusinessnumber, and sp_deletebusinessnumber are user-defined stored procedures.
• The value that is returned from the Get operation is mapped to the %BUSINESS_NUMBER% attribute.
• The question mark (?) indicates substitutions that are made at runtime before the query is executed. For example, in the Get operation the %USER_ID% well-known attribute is passed to the sp_getbusinessnumber stored procedure.