30937 - Length of DB2 error message increased

Problem Note 30937: Length of DB2 error message increased

Currently, when you are running a query against DB2 on z/OS, any error message that is returned to SAS from DB2 will be truncated at 141 characters. You now have the ability to increase the length of the returned error message to 240 characters. You can increase the length of the message by setting the macro variable SYS_DB2_MSG_FORMAT to LONG, which will result in a longer, but unformatted error message. Setting the macro to SHORT, or not defining the macro variable at all, will result in a message that truncates at 141 characters.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS/ACCESS Interface to DB2	z/OS	9.1 TS1M3	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#030937

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#030937

Type:	Problem Note
Priority:	high

Date Modified:	2008-02-20 13:43:36
Date Created:	2008-01-15 14:08:41