When querying a DB2 table that contains a BIGINT data type in SAS/ACCESS^® Interface to DB2 2026.07 and SAS/ACCESS^® Interface to DB2 2026.08, a Segmentation Violation error can occur.

ERROR:  An exception has been encountered.
Please contact technical support and provide them with the following traceback information:
 
The SAS task name is [SQL     ]
Segmentation Violation

In addition, the following issues might occur:

• When you use the CONTENTS procedure on the DB2 table, variables are shown as an INT type.
• Running SQL Pass-through code causes the BIGINT column to return a data value of 0.

This issue is fixed in SAS/ACCESS^® Interface to DB2 2026.09.

Workaround

To work around this issue, use the DBSASTYPE option to set your BIGINT column to a numeric type. For example, use the following syntax:

dbsastype=(bigIntColumnName='NUMERIC') 

Another workaround is to leave the BIGINT column off of your SELECT clause.