An attempt to retrieve rows or the count of rows from a table using FedSQL or DS2 might return unexpected results. The issue occurs when the table contains more than 2GB of rows and was created on a platform in which the C long data type is 32 bits. This includes MVS as well as both the 32-bit and 64-bit versions of Windows Vista, Windows XP, and Windows 7.

Here are some examples:

• The query select count (*) from table might return -1.
• The query select * from table might not return any data.

To circumvent the problem, use SAS^® 9.3 or SAS^® 9.4 to make a new copy of the data set while also setting the option EXTENDOBSCOUNTER=YES.

EXTENDOBSCOUNTER=YES is the default with SAS 9.4. EXTENDOBSCOUNTER= is available as a data set option and as an option in the LIBNAME statement in SAS 9.3 and 9.4. In SAS 9.4, it is also available as a system option.

Operating System and Release Information