This section shows example schemas and the generated instances.
Using Updategram SchemasYou can use updategrams to execute data manipulation commands and validate the responses. You can use updategram schemas as templates for generating updategrams.
Only send ports can execute updategrams. The examples in this section are of a solicit-response send port that has been configured to use the EnterpriseDB adapter. See the Adapter Configuration section in BizTalk for more information on configuring the adapter in send ports and receive locations.
Mapping the Request and Response to the Schema
Updategrams and updategram schemas have a declarative structure: A before block specifies the columns to update. An after block specifies how the data will change. The updategram schema maps to the types contained in the result of the command. The updategram instance maps to the values specified in the command.