In this blog post, let’s learn about the error message “201 A syntax error has occurred.” in Hydra and the description of the error.
Error Message
201 A syntax error has occurred.
Error Details
An SQL identifier exceeded the maximum number of characters. In Informix Dynamic Server 9.2x or 9.3, the maximum length for identifiers in SQL statements is 128 characters. In other Informix database servers, the maximum length for identifiers in SQL statements is 18 characters.
Check that no identifier in the statement is longer than the maximum length and that no punctuation error, such as a missing space or comma, combines two identifiers into one.