Potential Ambiguities and Syntax Errors

IBM® does not recommend using any keyword of SQL as an identifier, because to do so tends to make your code more difficult to read and to maintain. If you ignore this potential problem for human readers, however, you can use almost any keyword as an SQL identifier, but various syntactic ambiguities can occur. An ambiguous statement might not produce the desired results. The following sections identify some potential ambiguities and workarounds when keywords are declared as identifiers, or when different database objects have the same identifier.


Copyright© 2019 HCL Technologies Limited