SUPPORT / SAMPLES & SAS NOTES
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 |