Usage Note 35081: User-defined formats used with the PUT() function in an SQL statement cause an error in SAS® Scalable Performance Data Server
 |  |  |  |  |
Prior to SAS Scalable Performance Data Server 4.4 TSM8, if you use a user-defined format with the PUT() function in an SQL statement, the following error occurs:
SPDS_ERROR: Format XXX could not be loaded.
This functionality is now available when connecting from a Windows SAS Scalable Performance Data Server client (32- or 64-bit) to a UNIX platform running the SAS Scalable Performance Data Server, or when the client and server are both on the same platform.
Note, however, that you cannot use the PUT() function and user-defined format from a non-Windows client to a different server platform.
As a workaround, use the FORMAT= statement.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SPDS | Scalable Performance Data Server | Microsoft Windows 2000 Professional | 4.4 TSM0 | 4.4 TSM8 | 9.2 TS1M1 | |
| Microsoft Windows XP Professional | 4.4 TSM0 | 4.4 TSM8 | 9.2 TS1M1 | |||
| 64-bit Enabled AIX | 4.4 TSM0 | 4.4 TSM8 | 9.2 TS1M1 | |||
| 64-bit Enabled HP-UX | 4.4 TSM0 | 4.4 TSM8 | 9.2 TS1M1 | |||
| 64-bit Enabled Solaris | 4.4 TSM0 | 4.4 TSM8 | 9.2 TS1M1 | |||
| HP-UX IPF | 4.4 TSM0 | 4.4 TSM8 | 9.2 TS1M1 | |||
| Solaris for x64 | 4.4 TSM0 | 4.4 TSM8 | 9.2 TS1M1 | |||
A fix for this issue for SPD Server 4.4 is available at:
http://www.sas.com/techsup/download/hotfix/spds44.html#035081| Type: | Usage Note |
| Priority: |
| Date Modified: | 2009-08-07 13:45:26 |
| Date Created: | 2009-03-09 16:36:30 |