• Print |
• E-mail  |
• Bookmark

When using SAS/Access Interface to ODBC with SAS V8.2 on Windows to
connect to a NonStop Tandem database LARGEINT columns are being mapped
to DOUBLES in SAS, which is causing a loss of precision for the values.

This is complicated by the fact that many of these SQL_BIGINT columns
are key fields in the tables, which end up causing duplicate keys and
invalid results.

A hotfix is available that will basically map the SQL_BIGINT columns
into CHAR fields inside of SAS.  This will be activated via an OS
environment variable named ODBC_BIGINT_MASK, the value of which will be
a column mask for the columns to convert.  For now, the mask will only
accept two values, * and *abc.  * will mean to convert all BIGINT
columns into chars, where *abc will mean to only convert those BIGINT
columns that end in some sequence of characters, in this example, abc,

i.e.  mycolabc would be converted but mycol would not.

A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#007694

*** ATTENTION: To complete the installation of this hot fix on Windows
platforms, you must also download and install hot fix 82BB44 for
Windows from:

http://www.sas.com/techsup/download/hotfix/82_win_sbcs.html#82BB44

The hot fix will NOT be fully functional without both fixes applied.

Operating System and Release Information

A fix for Release 8.2 (TS2M0) for this issue is available at: