StarSQL is core SQL compliant, ODBC API version 2, level 1 compliant and also supports the additional level 2 ODBC functions.
StarSQL works with the ODBC Driver Manager version 2.0 and later, including 3.5.
StarSQL does not bypass RACF security, unless the verify=optional is coded in the APPL statement. Please see the DRDA Connectivity Guide for details.
StarSQL works with secondary authids. You may need to set it after you login with the command "SetCurrentSQLID="
Yes. You can use MTS with StarSQL for writing VB DLLs, or COM objects. The driver also works with connection pooling implemented by MTS.
In addition, StarSQL supports two phase commit processing over TCP/IP and APPC.
Yes, StarSQL works with ADO and ODBC.NET.
Yes. Use the Microsoft OLE/DB Provider for ODBC with your StarSQL data source to access relational table data on DB2. StarSQL does not have a direct OLE/DB interface at this time.
Yes, StarSQL can be used to import or export data using SQL Server DTS or SSIS packages, and StarSQL data sources can be used with SQL Server linked servers to access remote DB2 databases.