Return
-
Title
Editor Check Syntax option is flagging functions as identifiers, "identifier might conflict" -
Description
Editor Check Syntax option is flagging functions such as Hour, Year, etc as identifiers.
The following parser message appears also when hovering over the function name in Editor window:
"Found 'hour' The name of the identifier might conflict..." -
Resolution
WORKAROUND:
NoneSTATUS:
Waiting for fix to be released in a future version of Toad for DB2. -
Defect ID
ST112171 -
Additional Information
Targeted for 5.6. (formally Jira TDB-60) With the statement: SELECT * FROM TEST1 WHERE HOUR(PURCHASE) > 1; The syntax editor will flag HOUR as an identifier and issue a warning message. This behavior does not exist in 4.5, but was introduced in 4.6. The customer does not want functions to be flagged as an identifier. See attached.