Teradata SQL Error and Failure Codes from Error 9585 To 9596

SQLServerF1_Header_Small

9585 A column must not be part of more than one derived period column definition.
Explanation: A column cannot be both begin column and end column of a derived period column definition.
Generated By: RES modules
For Whom: The end user.
Remedy: Correct the statement and resubmit.

9586 A column cannot be both the begin column and end column of a derived period column definition.
Explanation: A column can be either a begin column or an end column of a derived period column definition, but not
both.
Generated By: RES modules
For Whom: The end user.
Remedy: Correct the statement and resubmit.

9587 Invalid use of a derived period column.
Explanation: The derived period column is not allowed in any other statement other than period predicates.
Generated By: RES modules
For Whom: The end user.
Remedy: Correct the statement and resubmit.

9588 Column %VSTR is part of derived period column definition and cannot be dropped.
Explanation: The columns participating in the derived period column cannot be dropped using ALTER TABLE.
Generated By: OPD modules
For Whom: The end user.
Remedy: Remove the derived period column and resubmit.

9589 Session qualifier cannot be set when nontemporal application compatibility mode is disabled.
Explanation: Session qualifier cannot be set when nontemporal application compatibility mode is disabled.
Generated By: RES modules
For Whom: The end user.
Remedy: Do not set the session qualifier in nontemporal application compatibility mode is disabled.

9590 Nontemporal application compatibility mode changed to %VSTR.
Explanation: Nontemporal application compatibility mode is changed between the database restarts.
Generated By: CTX modules
For Whom: The end user.
Remedy: Nontemporal application compatibility mode is changed between the database restarts.
9591 Normalize column must be a period column.
Explanation: When a table is DDL normalized, then the <Normalize column> must be a period data type column or a
pseudo period column.
Generated By: RES module.
For Whom: End User.
Remedy: Correct statement and resubmit.

9592 NORMALIZE is not allowed on a transaction time column.
Explanation: When a table is DDL normalized, then the <Normalize column> must not be transaction time column.
Generated By: RES module.
For Whom: End User.
Remedy: Correct statement and resubmit.

9593 LOB columns must be part of normalize ignore columns list.
Explanation: When a table is DDL normalized, A LOB column if present in the table definition must be included in the
ignore column list.
Generated By: RES module.
For Whom: End User.
Remedy: Correct statement and resubmit.

9594 A table already has a normalize definition.
Explanation: A table can have only one normalize column, adding another normalize column reports a new error.
Generated By: RES module.
For Whom: End User.
Remedy: Correct statement and resubmit.

9595 NORMALIZE option definition not allowed.
Explanation: The <normalize option definition> cannot be specified on a target table for CREATE TABLE AS statement.
Generated By: RES module.
For Whom: End User.
Remedy: Correct statement and resubmit.

9596 Invalid use of normalize period column.
Explanation: For triggers, normalize period column specification in newrow or newtable is not allowed.
Generated By: RES module.
For Whom: End User.
Remedy: Correct statement and resubmit.

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