Known Open Client Limitations of SAP Sybase IQ

Using the Open Client interface, you can use an SAP Sybase IQ database in much the same way as you would an Adaptive Server Enterprise database. There are some limitations, including the following:

• SAP Sybase IQ does not support the Adaptive Server Enterprise Commit Service.

• A client/server connection's capabilities determine the types of client requests and server responses permitted for that connection. The following capabilities are not supported:

  • CS_CSR_ABS
  • CS_CSR_FIRST
  • CS_CSR_LAST
  • CS_CSR_PREV
  • CS_CSR_REL
  • CS_DATA_BOUNDARY
  • CS_DATA_SENSITIVITY
  • CS_OPT_FORMATONLY
  • CS_PROTO_DYNPROC
  • CS_REG_NOTIF
  • CS_REQ_BCP

• Security options, such as SSL, are not supported. However, password encryption is supported.

• Open Client applications can connect to SAP Sybase IQ using TCP/IP.

  For more information about capabilities, see the Open Server Server-Library C Reference Manual.

• When the CS_DATAFMT is used with the CS_DESCRIBE_INPUT, it does not return the data type of a column when a parameterized variable is sent to SAP Sybase IQ as input.