Skip to main content

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

  • February 15, 2013
  • 0 replies
  • 0 views

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