Teradata SQL Error and Failure Codes from Error 6916 To 6925

6916 TOP N Syntax error: %VSTR.
Explanation: The TOP N option is not supported in subqueries and join indexes. WITH caluse is not allowed as well.
Generated By: Res modules
For Whom: End Users.
Remedy: Don’t use Top N option in subquery and join indexes. Also avoid use Top N in queries with WITH clause.

6917 Illegal or unsupported use of negation inside a recursive query/view.
Explanation: A NOT IN or NOT EXISTS or NOT …(…IN…) clause is being used inside the recursive query/view.
Generated By: SYN/RES modules
For Whom: End User
Remedy: Examine the SQL statement and verify that the request is correct. Change the statement to adhere to the recursive
query rules and resubmit the request.

6918 Illegal or unsupported use of an aggregation, ordered analytical, aggregate user-defined function or user-defined method inside a recursive query/view.
Explanation: An aggregation, ordered analytical,user-defined function or user-defined method is being used inside the
recursive query/view, which is not allowed.
Generated By: SYN/RES modules
For Whom: End User
Remedy: Examine the SQL statement and verify that the request is correct. Change the statement to adhere to the recursive
query rules and resubmit the request.

6919 A recursive reference cannot be part of an inner relation of a left/right/full outer join.
Explanation: A LEFT/RIGHT/FULL OUTER JOIN is being used inside the recursive query, which is not allowed.
Generated By: SYN/RES modules
For Whom: End User
Remedy: Examine the SQL statement and verify that the request is correct. Change the statement to adhere to the recursive
query rules and resubmit the request.

6920 A non-recursive WITH clause or view should not reference itself within its own definition.
Explanation: A query name or relation is being referenced inside its own definition, which is not allowed. This could be
a non-recursive WITH clause or a CREATE VIEW statement.
Generated By: SYN/RES modules
For Whom: End User
Remedy: Examine the SQL statement and verify that the request is correct. Convert the statement into a recursive statement
by using a WITH RECURSIVE or CREATE RECURSIVE VIEW clause if the query name needs to be referenced in its
own definition. Otherwise, remove the query name reference from the non-recursive WITH or VIEW definition and resubmit
the request.

6921 A recursive query/view definition should not contain more than one recursive relation reference in each FROM clause.
Explanation: Recursive relation is being referenced more than once in the FROM clause in the recursive query/view,
which is not allowed.
Generated By: SYN/RES modules
For Whom: End User
Remedy: Examine the SQL statement and verify that the request is correct. Change the statement to adhere to the recursive
query rules and resubmit the request.

6922 Illegal or unsupported use of subquery/derived table inside a recursive query/view.
Explanation: A subquery or derived table is being used inside the recursive statement of a recursive query/view, which
is not allowed.
Generated By: SYN/RES modules
For Whom: End User
Remedy: Examine the SQL statement and verify that the request is correct. Change the statement to adhere to the recursive
query rules and resubmit the request.

6923 Unsupported use of GROUP BY/extended grouping clause inside a recursive query/view.
Explanation: A GROUP BY or an extended grouping operation is being performed inside the recursive statement of a
recursive query/view, which is not allowed.
Generated By: SYN/RES modules
For Whom: End User
Remedy: Examine the SQL statement and verify that the request is correct. Remove the GROUP BY or Extended grouping
operator from the recursive statement and resubmit the request.

6924 Illegal or unsupported set operation inside a recursive query/view.
Explanation: A set operation like UNION, INTERSECT, INTERSECT ALL, MINUS, MINUS ALL, EXCEPT, or EXCEPT
ALL is being used inside the recursive query/view, which is not allowed.
Generated By: SYN modules
For Whom: End User
Remedy: Examine the SQL statement and verify that the request is correct. Change the statement to adhere to the recursive
query rules and resubmit the request.

6925 Unsupported use of DISTINCT inside a recursive query/view.
Explanation: A DISTINCT clause is being used inside the recursive statement of a recursive query/view, which is not
allowed.
Generated By: SYN/OPT modules
For Whom: End User
Remedy: Examine the SQL statement and verify that the request is correct. Remove the DISTINCT modifier from the
recursive statement and resubmit the request.

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