Teradata SQL Error and Failure Codes from Error 5398 To 5409

SQLServerF1_Header_Small

5398 SELECT/FETCH source list and INTO list do not match.
Explanation: The SELECT expresion list and the INTO list do not have the same number of entries. sample SQLs that
can cause this error: select col1 into :var1, :var2 from table1; or select col1, col2 into :var1 from table1;
Generated By: RES modules
For Whom: End User.
Remedy: Correct the SELECT-INTO and resubmit.

5399 Bad argument type to UPPER or LOWER function.
Explanation: The argument to UPPER or LOWER function was not of CHAR or VARCHAR type.
Generated By: OPT modules
For Whom: End User.
Remedy: Correct the request and resubmit the request.

5400 Number of leading digits out of range.
Explanation: The number of leading digits of an INTERVAL data type must be between 1 and 4.
Generated By: SYN
For Whom: End User.
Remedy: Use values within range.

5401 Number of fractional digits out of range.
Explanation: The number of optional fractional digits of an INTERVAL data type must be between 1 and 6.
Generated By: SYN
For Whom: End User.
Remedy: Use values within range.

5402 WITH TIME ZONE is incompatible with specified data type.
Explanation: WITH TIME ZONE must follow either TIME or TIMESTAMP.
Generated By: SYN
For Whom: End User.
Remedy: Correct the syntax, and resubmit the request.

5403 WITH TIME ZONE must follow either TIME or TIMESTAMP.
Explanation: WITH TIME ZONE must follow either TIME or TIMESTAMP.
Generated By: SYN
For Whom: End User.
Remedy: Correct the syntax, and resubmit the request.

5404 Datetime field overflow.
Explanation: The evaluation of a <datetime value expression> results in a value outside of the permissible range for any
contained field or the result is invalid based on the natural rules for dates and times.
Generated By: SYN and OPT modules
For Whom: End User.
Remedy: Change the datetime value expression such that it represents a valid datetime value.

5405 Interval field overflow.
Explanation: The evaluation of an <interval value expression> results in a value greater than the precision defined for
the the target field.
Generated By: SYN and OPT modules
For Whom: End User.
Remedy: Change the interval value expression such that it represents a valid interval value of the given precision.

5406 Invalid combination of Teradata and ANSI datetime value functions.
Explanation: An attempt was made to intermix Teradata and ANSI datetime value functions.
Generated By: RES
For Whom: End User.
Remedy: Correct the request and resubmit it.

5407 Invalid operation for DateTime or Interval.
Explanation: An operation that requires an appropriate DateTime or Interval data type or value, and it does not.
Generated By: RES, OPU, MOVEROW
For Whom: End User.
Remedy: Correct the request and resubmit it.

5408 Invalid operands to OVERLAPS operator.
Explanation: The arguments of OVERLAPS must be of appropriate DateTime or Interval types.
Generated By: OPT
For Whom: End User.
Remedy: Correct the request and resubmit it.

5409 Invalid DATE Literal.
Explanation: The value of the literal does not represent a valid date.
Generated By: MOVEROW
For Whom: End User.
Remedy: Correct the request and resubmit it.

Above are list of Teradata Errors or Failure Codes from Error 5398 To 5409 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 *