Troubleshooting
Problem
Users have programs that have SQL queries with a not equals by using the 'shift + 6' key and IDz gives an error on this but it is valid SQL syntax.
Symptom
The character before the = sign is where it is failing but that is a valid SQL syntax code.
SUM(CASE when error_nmb is null then +0
when ERROR_NMB ¬= ' ' THEN +1
else +0
END) AS ERR_CNT
SUM(CASE when error_nmb is null then +0
when ERROR_NMB ¬= ' ' THEN +1
else +0
END) AS ERR_CNT
Environment
zOS
Resolving The Problem
Within IDz the code pages that support this symbol are not listed as an option in the Mapping Preferences.
Work-Around:
Change the "logical not" to != or ˆ= then the syntax error goes away in the editor.
Change the "logical not" to != or ˆ= then the syntax error goes away in the editor.
Document Location
Worldwide
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSJK49","label":"IBM Developer for z Systems"},"Component":"","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Product Synonym
RTC; Developer for z; IDz; RDz
Was this topic helpful?
Document Information
Modified date:
27 June 2019
UID
ibm10957475