Teradata SQL Error and Failure Codes from Error 5818 To 5830

SQLServerF1_Header_Small

5818 Synonyms for Operators or Keywords are not ANSI.
Explanation: A non-ANSI synonym has been used for a Keyword or Operator.
Generated By: SYN modules.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5819 ame = expression is not ANSI syntax in INSERT list.
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.

5820 @ ame is not ANSI.
Explanation: The syntax is not the ANSI syntax for parameters.
Generated By: SYN modules.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5821 Built-in values DATE and TIME are not ANSI.
Explanation: These values are not supported in ANSI.
Generated By: SYN modules.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5822 CREATE TABLE includes a non-ANSI Option.
Explanation: ANSI does not support an option included in the CREATE TABLE statement.
Generated By: SYN modules.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5823 This form of CREATE TABLE is not ANSI.
Explanation: The CREATE TABLE statement includes non-ANSI syntax.
Generated By: SYN modules.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5824 Constraint name is not in Entry Level ANSI.
Explanation: Entry level ANSI does not support named constraints.
Generated By: SYN modules.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5825 A declared Data Type is not ANSI.
Explanation: A non-ANSI data type declaration has been used.
Generated By: SYN modules.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5827 ALL BUT as privilege designator is not ANSI.
Explanation: Non-ANSI syntax has been used in designating privileges.
Generated By: SYN modules.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5828 PRIVILEGES keyword is required in ANSI.
Explanation: The keyword PRIVILEGES is required in this statement.
Generated By: SYN modules.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5829 A designated Privilege is not ANSI.
Explanation: A non-ANSI privilege has been listed.
Generated By: SYN modules.
For Whom: User.
Remedy: If script is to be full ANSI compliant, change the indicated statement.

5830 ROLLBACK WORK cannot indicate a condition or return text to user in ANSI.
Explanation: ANSI does not support returning a message on ROLLBACK WORK.
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 5818 To 5830 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 *