18039 - "ERROR: numeric expression requires numeric format"

Problem Note 18039: "ERROR: numeric expression requires numeric format"

One or both of the following error messages may be issued when using SAS/ACCESS^® Interface to MySQL to access a table with a LONGTEXT or LONGBLOB data type using SAS 9.1.3 Service Pack 4. This problem does not occur with SAS^® 9.1.3 Service Pack 3.

  ERROR: Numeric expression requires numeric format.

  ERROR: Length of the numeric variable content must be between 3 and 8.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS/ACCESS Interface to MySQL	Linux	9.1 TS1M3 SP4	9.2 TS1M0
		64-bit Enabled Solaris	9.1 TS1M3 SP4	9.2 TS1M0
		64-bit Enabled HP-UX	9.1 TS1M3 SP4	9.2 TS1M0
		64-bit Enabled AIX	9.1 TS1M3 SP4	9.2 TS1M0

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#018039

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :

http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#018039

Type:	Problem Note
Priority:	high

Date Modified:	2006-08-10 11:21:54
Date Created:	2006-07-11 13:09:39