Teradata SQL Error and Failure Codes from Error 5806 To 5817

5806 Empty INSERT list is not ANSI.
Explanation: An insert has been submitted with an empty insert list.
Generated By: SYN modules.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5807 Empty INSERT list entry is not ANSI.
Explanation: An INSERT has been submitted with an empty entry in its insert list.
Generated By: SYN modules.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5808 ANSI DELETE/UPDATE does not permit alias of Table.
Explanation: An UPDATE or DELETE has been issued with an alias on the table.
Generated By: SYN modules.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5809 SET keyword in ANSI UPDATE is required.
Explanation: ANSI UPDATE requires the SET keyword in the syntax.
Generated By: SYN modules.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5810 ALL keyword in DELETE or UPDATE is not ANSI.
Explanation: ANSI does not allow the ALL keyword in DELETE or UPDATE.
Generated By: SYN modules.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5811 MINUS of queries is not in Entry Level ANSI.
Explanation: A query that includes MINUS is not in Entry Level ANSI.
Generated By: SYN modules.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5812 Comparison of Lists is not ANSI.
Explanation: Comparison of lists versus sets of columns is not in ANSI.
Generated By: SYN modules.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5813 COUNT without DISTINCT is restricted to COUNT (*).
Explanation: COUNT [ALL] <expression> is not supported in entry level ANSI.
Generated By: ResName Module.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5814 Operator used is not ANSI.
Explanation: An operator not in ANSI has been used in an expression.
Generated By: SYN modules.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5815 Function is not ANSI.
Explanation: A non-ANSI function has been used in an expression.
Generated By: SYN modules.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5816 DISTINCT on SET operation must be on a column reference.
Explanation: AVG, MAX, MIN, SUM or COUNT has specified DISTINCT and has an argument that is not a column reference.
Generated By: ResName module.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5817 IS [NOT] IN is not ANSI syntax.
Explanation: The syntax used is not ANSI.
Generated By: SYN modules.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

Above are list of Teradata Errors or Failure Codes from Error 5806 To 5817 received while performing certain operation against Teradata Database or related products.

What are Teradata Database Errors?

In general, each Teradata error message contains the following information:
• The message number.
• The message text. This text is usually returned with the message number. Some messages employ word substitution, where the word substituted represents the system-replacement of a term more specific to the occurrence.
• An explanation of how the error may have occurred.
• Generated-by text that indicates the software module which initiated the message. This field serves a diagnostic purpose for support and development personnel.
• A remedy which suggests how to resolve the condition.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Teradata SQL Error and Failure Codes and Error Messages on Windows, Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *