UseDSCRDBTBL

If the UseDSCRDBTBL setting is Yes, StarSQL uses the DRDA DSCRDBTBL command to implement the SQLColumns ODBC function. Yes is the default. When UseDSCRDBTBL is set to Yes StarSQL does not treat an underscore ("low line") as a wildcard when using the DSCRDBTBL DRDA command. This can improve compatibility with some applications.

For hosts that do not support the DRDA DSCRDBTBL command, such as SQL/DS, DB2/UDB, or any host in a double-byte environment, set UseDSCRDBTBL to No. When UseDSCRDBTBL is set to No, StarSQL implements SQLColumns by preparing and executing a SELECT command. In addition, the underscore character is treated as a wildcard when UseDSCRDBTBL is set to No.