SQL Command SchemasCData BizTalk Adapter for FedEx 2019 - Build 19.0.7354
SQL command schemas allow you to retrieve and update FedEx data in BizTalk through an SQL interface. For example, you can execute a parameterized query when a message is received, with the message containing the input parameter values.
Executing SQL Statements
The following sections show example requests, responses, and schemas for the appropriate ports.
SELECT Command Schemas
You can execute SELECT commands by generating SELECT Command Schemas for both receive locations and solicit-response send ports.
INSERT Command Schemas
You can execute INSERT statements by generating INSERT Command Schemas for send ports.
UPDATE Command Schemas
You can execute UPDATE statements by generating UPDATE Command Schemas for send ports.
DELETE Command Schemas
You can execute DELETE statements by generating DELETE Command Schemas for send ports.