Problem Note 38127: An error occurs when you attempt to publish DB2 user-defined formats
 |  |  |  |  |
An error message might be issued when you attempt to create and use DB2 user-defined formats in a query with the DB2 command-line processor, similar to the following:
db2 => select sas_put(state,'$STATEC.') as price_c from mailorderdemo
The intrinsic formats are created and used successfully. However, the user-defined formats only appear to be created and published successfully, and the following error message is generated:
PRICE_C -------------------------------------------------------------------------- SQL0430N User defined function "FORMATS.SAS_PUT" (specific name "SQL090910152711600") has abnormally terminated. SQLSTATE=38503
Because the user-defined formats are not published successfully, the scoring-model and the SAS_PUT functions will not be compatible with the jazxfbrs library, and the the user-defined formats will not work correctly.
Click 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 Scoring Accelerator for DB2 | Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows Vista | 9.2 TS2M2 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 9.2 TS2M2 | 9.2 TS2M3 | ||
A fix for this issue for SAS Formats Library for DB2 1.6 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A79.html#38127| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> DB2 |
| Date Modified: | 2009-12-17 13:35:05 |
| Date Created: | 2009-12-14 08:59:25 |