How to Execute Commands in the Host File System

After establishing a connection to a data source, you can execute commands and return results from the data source using HostFileCommand.

Important

The Managed Provider for Host Files does not support any type of transaction. Therefore, you should try to avoid using INSERT, UPDATE, or DELETE commands on mission-critical data.

Procedure

To execute a command on the host file system

1. Establish a connection using HostFileConnection.

   For more information, see How to Connect to and Disconnect from a Host File System.

2. Once connected, create a HostFileCommand object by using HostfileConnection.CreateCommand.

3. Use the HostFileCommand object to execute commands on the Host File system.

   HostFileCommand exposes several Execute methods that you can use:

   • When returning results as a stream of data, use ExecuteDbDataReader to return a DataReader object.

   • Use ExecuteScalar to return a singleton value.

   • Use ExecuteNonQuery to execute commands that do not return rows.

   • Use ExecuteRecordSet to execute commands on a recordset.

Note

When modifying an Alternate Index File (AIX), you may receive an "Invalid record length" error when the Index is defined not to accept duplicate keys. This error may occur because the INDEX of the Alternate Index VSAM file is not large enough to hold multiple key values for the same index record .

See Also

Working with the Managed Data Provider For Host Files
BizTalk Adapter for Host Files Configuration