SQL parameter element and tags

NSM service designers use the <sqlParameter> element and the <name>, <description>, <arguments>, and <sql> tags to define SQL parameters in the NSM service template XML when designing NSM service templates. SQL parameters can be passed as arguments to inject, other SQL, or HTTP parameters. HTTP parameters can be used as both global and local parameters in a NSM service template.

The following sample XML shows the layout of the SQL parameter element and tags.

<sqlParameters>
	<sqlParameter>
		<name>DESTINATIONADDRESS</name>
		<description>A description of the DESTINATIONADDRESS parameter</description>
		<arguments>SOURCEADDRESS</arguments>
		<sql>select VLAN_ID from VLAN where uniquekey = ?</sql>
	</sqlParameter>
</sqlParameters>

Table 1. SQL parameter element and tag details
Tag	Type	Description
`<sqlParameters>`	Container list	Contains a list of one or more `<sqlParameter>` elements.
`<sqlParameter>`	Container	Contains the SQL parameter details. Each SQL parameter is encapsulated within a `<sqlParameter>` `</sqlParameter>` element pair.
`<name>`	String	Specifies the name of the SQL parameter. In the example, the name of the SQL parameter is `DESTINATIONADDRESS`.
`<description>`	String	Specifies the description of the SQL parameter. In the example, the description of the SQL parameter is `A description of the DESTINATIONADDRESS parameter`.
`<arguments>`	Comma-separated string	Specifies a comma delimited list of parameters that are used in the SQL statement. In the example, the SQL parameter argument is `SOURCEADDRESS`.
`<sql>`	SQL statement	Specifies the select SQL statement with arguments, which are denoted by the `"?"` symbol in the example.