Open Server-to-ODBC Datatypes

An access service converts or performs SQL transformation on incoming Open Server data it receives in a client request.

The access service does not perform automatic incoming datatype conversions on data values embedded in strings or received as parameters. Instead, the client application receives a string template from the target datatypes so that it can format the strings correctly before sending them to the target DBMS. The formatting is set up through the sp_columns catalog stored procedure.

• Data Values Embedded as Strings
  When the access service receives a SQL command with embedded data values, the SQL transformation mode determines whether any transformation is applied to these values.
• Data Values Received as Parameters
  When an access service receives data values as parameters to RPC commands, cursor commands, or dynamic SQL commands, it converts Open Client and Open Server datatypes to default target DBMS datatypes.
• CS_DATAFMT usertype Field Values
  The usertype field of the CS_DATAFMT structure is a 32-bit integer.
• Datatype Names
  An access service receives datatype names as part of create table or alter table commands.