Decimal Delimiter
In Europe the decimal delimiter is often set to be comma character. DB2 database configured this way will return SQL syntax error in the following cases:
• select ....,1,
• insert ....values(...1,2,3...)
• insert ....values(...1 ,2,...)
• order by 1,2,3
• order by 1 ,2
• update...set abc=1,def='XX'
• case (? as varchar(50),12
To avoid this problem, surround the comma with spaces.
Parent topic