SQL Options on the General Tab

SQL options affect the interactions among the driver, SAS, and applications that are ODBC compliant. The default settings for the SQL options are those that most ODBC-compliant applications expect and work best with. However, you can override the default settings by selecting any of the SQL options that are listed. Select the check box to enable the SQL option.

Preserve trailing blanks

preserves trailing blanks at the end of character fields. The default is that trailing blanks are removed so that each field ends in a null value.

Support VARCHAR

causes character fields that are longer than 80 characters to be reported as variable-length fields, and causes the trailing blanks to be removed. For more information, see Support VARCHAR Option.

Infer INTEGER from FORMAT

causes SAS numeric data types (typically reported as SQL_DOUBLE) to be reported as SQL_INTEGER. For more information, see Infer INTEGER from FORMAT Option.

Disable _0 override parsing

prevents the driver from removing the _0 string from SQL queries. For more information, see Disable _0 override parsing Option.

Use client code page

tells the driver to use the client's code page information when transcoding multi-byte characters to and from WideChar. If this option is not selected, the server's code page information is used.

DQUOTE=ANSI

strings enclosed in double quotation marks are treated as variables. This feature enables you to use reserved words such as AS, JOIN, and GROUP as table names, column names, or aliases. It also enables using DBMS names and other names that are not normally permissible in SAS when the values are enclosed in double quotations marks. The VALIDVARNAME=ANY system option is also set by the driver to enable non-ASCII characters to be used in column names when the value is enclosed in double quotation marks. If non-ASCII characters are needed in a table name and a SAS 9.3 or later SAS/SHARE server is used, then enclose the table name in double quotation marks and enable the VALIDMEMNAME=EXTEND system option in a SAS/SHARE server configuration file. When this option is not selected, values within double quotation marks are treated as strings.

Return SQLTables REMARKS

causes the driver to read and return the SAS data set label for each data set in the library you are accessing. (SQLTables is the name of an ODBC function that can be used for this purpose.) For SAS data sets, this task can have a negative impact on performance, because each data set must be opened to read and return the label. Therefore, you should not select this option unless there is information in the label that you need.

UNDO_POLICY=REQUIRED

implements the UNDO_POLICY option of the SAS SQL procedure with a setting of REQUIRED. With this setting enabled, INSERT or UPDATE statements that fail are undone. However, this option is only for statements that affect multiple records. This option has no effect for an SQL statement that affects a single record. When UNDO_POLICY=REQUIRED, the associated statement handle (hstmt) of an UPDATE or INSERT statement must be the only active hstmt against the table. If another user or an hstmt within the same user's application has an active SELECT statement, then the UPDATE or INSERT statement fails.

Fuzz Numbers at N Places

specifies the degree of precision to use when comparing numbers. For more information, see Fuzz Numbers at N Places Option. By default, this option is selected. You can change the default value of 12 by typing over it.

Infer type in min/max functions

tells the driver to attempt to determine the format of the column used as input to a MIN or MAX function, and to use that format to infer the SQL type of the column.

Quote Char is NULL

tells the driver to use an empty string for the SQLGetInfo(SQL_IDENTIFIER_QUOTE_CHAR) method when this option is enabled. When this option is not enabled, the driver returns a blank space. This option should be enabled only when directed by SAS Technical Support or the application vendor.