About the Mapping and Binding Process

Before an OLE DB consumer can read, update, or insert a row into a table, the following two steps must be taken:
  1. The SAS providers must use OLE DB constructs to give to the application the information about the columns in the data store.See Returning Column Metadata.
  2. The client application (the consumer) must give to the data provider the following specific information about the columns:
    • which columns will be manipulated
    • what type they will be accessed as
    • where they will be stored in the client's memory
The process of communicating this information to the provider is called column binding. Column binding is done by using the OLE DB accessors. See Binding to Rowset Columns.