Teradata SQL Error and Failure Codes from Error 6972 To 6981

6972 WITH DEFAULT is not allowed on a PERIOD(TIME) column.
Explanation: The WITH DEFAULT option is not allowed on a PERIOD(TIME) column. The default value for a
PERIOD(TIME) column can be set using a Period value constructor or a Period literal.
Generated By: Parser.
For Whom: End User.
Remedy: Rewrite the statement without using WITH DEFAULT on PERIOD(TIME).

6973 Invalid argument for the %VSTR function. The argument must have a Period data type.
Explanation: The argument of the BEGIN || END ||LAST ||INTERVAL function must have a Period data type and be
a Period value expression.
Generated By: Parser.
For Whom: End User.
Remedy: Correct the argument to be a Period value expression and re-submit.

6974 Invalid interval qualifier for the INTERVAL function. The interval qualifier must be one that is allowed for the argument’s Period data type.
Explanation: The specified interval qualifier of the INTERVAL function is not allowed for the argument’s Period data
type. If the argument has PERIOD(DATE) data type, the interval qualifier must be YEAR, YEAR TO MONTH, MONTH, or
DAY. If the argument has PERIOD(TIME(n) [WITH TIME ZONE]) data type, the interval qualifier must be HOUR, HOUR
TO MINUTE, HOUR TO SECOND, MINUTE, MINUTE TO SECOND or SECOND. If the argument has PERIOD(TIMESTAMP(
n) [WITH TIME ZONE]) data type, any interval qualifier is allowed.
Generated By: Parser.
For Whom: End User.
Remedy: Correct the argument and resubmit

6975 Invalid argument for the %VSTR function. The argument must have a DateTime data type.
Explanation: The argument of the PRIOR or NEXT function must have a DateTime data type and be a DateTime value
expression.
Generated By: Parser modules.
For Whom: End User.
Remedy: Correct the argument to be a DateTime Data Type and re-submit.

6976 Period data types are not allowed with %VSTR function.
Explanation: A Period value is not allowed for this function.
Generated By: Parser.
For Whom: End User.
Remedy: Rewrite the statement without using a Period value or use a function that allows a Period value and re-submit.

6977 Invalid Period value constructor. The beginning and ending bounds must have the same DateTime data type.
Explanation: For the construction of a period value,the specified beginning and ending bounds must have the same
DateTime type.If any other data type other than DateTime type is passed as an argument to the PERIOD value constructor,
it must be explicitly CAST.
Generated By: Parser.
For Whom: End User.
Remedy: Correct the values and re-submit.

6978 Invalid Period value constructor. An ending bound of UNTIL_CHANGED is not allowed for PERIOD(TIME).
Explanation: UNTIL_CHANGED cannot be used in the construction of a PERIOD(TIME) value. It is allowed as the ending
bound in construction of a PERIOD(DATE) or PERIOD(TIMESTAMP) value.
Generated By: Parser.
For Whom: End User.
Remedy: Correct the values and re-submit.

6979 Invalid CAST. Casting a Period value as the specified target type is not allowed.
Explanation: A Period value can be cast only as CHARACTER, VARCHAR, PERIOD , DATE, TIME, or TIMESTAMP
when using the CAST function. Using the CAST function for casting a Period value as any other data type is not allowed.
Note that a PERIOD(DATE) value cannot be cast as PERIOD(TIME) or TIME. Also, a PERIOD(TIME) value cannot be cast
as PERIOD(DATE) or DATE.
Generated By: Parser modules.
For Whom: End User.
Remedy: Rewrite the statement by correcting the source value to have a data type such that it is valid to cast the source
value as the specified target type and re-submit.

6980 Invalid CAST. Casting the specified source value as PERIOD is not allowed.
Explanation: Only a CHARACTER, VARCHAR, PERIOD, DATE, TIME, or TIMESTAMP value can be cast as a Period
data type. Using the CAST function for casting a value of any other data type is not allowed. Note that a PERIOD(DATE) or
DATE value cannot be cast as PERIOD(TIME). Also, a PERIOD(TIME) or TIME value cannot be cast as PERIOD(DATE).
Generated By: Parser.
For Whom: End User.
Remedy: Rewrite the statement by correcting the source value to have a data type such that it is valid to cast the source
value as the specified target type and re-submit.

6981 Invalid CAST. Casting a DATE value as PERIOD(TIME) is not allowed.
Explanation: A DATE value cannot be cast as PERIOD(TIME).
Generated By: Parser.
For Whom: End User.
Remedy: Rewrite the statement by correcting the source value to have a data type such that it is valid to cast the source
value as the specified target type and re-submit.

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