15.00 - 6916 TOP N Syntax error: %VSTR. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

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.