You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
On case statements, the keyword then has surrounding spaces removed.
"values case when 12 <> 4 then 'A' else 'B' end" becomes "values case when 12<>4then'A'else'B'end". Its odd that "case when FIELD = 'Y" then -1 else 1 end becomes "case when FIELD='Y'then-1 else 1 end" seems to be okay.
A similar issue exists with date/time calculations,"values DATE_FIELD -6 days" becomes "values DATE_FIELD-6days"
Issues with an IBM i DB2 system.
The text was updated successfully, but these errors were encountered:
On case statements, the keyword then has surrounding spaces removed.
"values case when 12 <> 4 then 'A' else 'B' end" becomes "values case when 12<>4then'A'else'B'end". Its odd that "case when FIELD = 'Y" then -1 else 1 end becomes "case when FIELD='Y'then-1 else 1 end" seems to be okay.
A similar issue exists with date/time calculations,"values DATE_FIELD -6 days" becomes "values DATE_FIELD-6days"
Issues with an IBM i DB2 system.
The text was updated successfully, but these errors were encountered: