Problem Note 17707: Order by list with column numbers need spaces after each comma when DB2DECPT is set to a comma
 |  |  |  |  |
When using an ORDER BY with column numbers instead of column names a space is needed after each comma when the system option DB2DECPT= has been set to a comma (db2decpt=','). There are occasions when the SAS/ACCESS® to DB2 product is not including a space when it builds the code that it is sending to DB2 to be processed. This will cause problems for sites that used a comma for a decimal point.
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 DB2 | z/OS | 9.1 TS1M3 | 9.2 TS1M0 |
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#017707A 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#017707| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> DB2 SAS Reference ==> LIBNAME Engines |
| Date Modified: | 2006-06-06 15:00:00 |
| Date Created: | 2006-05-16 14:25:02 |