Error (pos: 78 '...from PUBLIC.^DESC')

0 Likes

Problem:

Upon execution of the query

     SELECT * FROM PUBLIC.DESC

the following error was returned

     "(pos: 78 '...from PUBLIC.^DESC')"

Resolution:

The error indicates that the syntax error begins at the location of the '^' symbol. In this case, the table name "DESC" is a reserved word in most database systems, thus it is not allowed as a user defined table name.  Renaming the table to a non-reserved word should avoid this error.

Old KB# 2850
Comment List
Anonymous
Related Discussions
Recommended