The following table provides a list of IOM Data Provider recipes and their descriptions.
| This recipe... | Explains how to do this... |
|---|---|
| Opening an ADO Connection Object | Open an ADO Connection object. Lists required and optional connection properties for each of the SAS Data Providers. |
| Making Connections by Using the Microsoft Data Link API | Use the Microsoft Data Link API to prompt users for OLE DB connection information at run time and to provide persistent connection information for the SAS Data Providers. |
| Controlling Data Access Permissions with a Connection | Set permissions on your data source. |
| Reusing an Existing IOM Workspace | Associate a running SAS workspace object with an ADO Connection object. |
| Assigning a Libref to Use with the IOM Provider | Assign a libref when using the IOM Data Provider to open or create a table. Explains how to execute a LIBNAME statement through an ADO or OLE DB Command object and how to use the AssignLibref method from the IOM DataService class. |
| Connecting to a Remote IOM Server | Establish a connection to a remote SAS IOM Server. Explains how to set properties on the ADO Connection object and how to create a SAS workspace using the SAS Integration Technologies Workspace Manager. |
| Identifying a Data Set to Open | Specify a data set depending on which SAS provider you are using. |
| Opening a Password-Protected Data Set | Open a data set that requires a password. |
| Padding Character Data with Blanks | Force the SAS Data Providers to preserve trailing blanks. |
| Updating Records | Perform recordset updates, including how to handle batch updates. |
| Reading a SAS/ACCESS Data Set | Access third-party data stores that are available through your licensed SAS/ACCESS engines. |
| Implementing a Locking Strategy | Lock records that you are updating to prevent data loss. |
| Creating and Deleting Data Sets | Create and delete data sets. Explains how to use SQL CREATE TABLE and DROP TABLE statements; how to use Microsoft ActiveX Data Object Extensions for DDL and Security (ADOX); and how to use the OLE DB ITableDefinition interface. |
| Executing SQL Queries and Commands | Execute SQL queries and commands. |
| Reading Missing Values from a Data Set | Test for missing values. |
| Writing Missing Values to a Data Set | Write missing values to a data set. |
| Using Formats When You Read Data | Obtain access to SAS formatting features when reading data. |
| Using Informats When You Write Data | Obtain access to SAS informatting features when writing data. |
| Applying User-Written Formats and Informats | Open data sets that include user-written formats and informats created using the SAS FORMAT procedure. |
| Displaying Metadata Specific to SAS | Display metadata that is specific to SAS data sets. |