Consultor Eletrônico

Status: Verified

GOAL:

How to troubleshoot error 7519 with SQL-92

GOAL:

What could be causes for error 7519 when using SQL-92?

GOAL:

Table/View/Synonym not found (7519)

FACT(s) (Environment):

All Supported Operating Systems
Progress 9.x
OpenEdge 10.x

FIX:

Table/View/Synonym not found (7519) indicates that an object used in a SQL statement is not available in the current schema or in the database.

When this error is encountered, determine whether the table, view, or synonym is in the current schema or in the database.

This error can occur when accessing a table from the PUB schema without prefixing the table with PUB.

Possible causes and solutions for Error 7519 are:

NOTE: Schema names are capitalized for emphasis only.
1) The PUB schema prefix is not specified for a 4GL table.

Solution: Prefix the name of the table, view, or synonym with PUB.



A) select * from customer
B) change to: select * from PUB.customer 2) The specified name has hyphens and/or is a reserved word.


Solution: Enclose the name in double quotes.


A) select * from PUB.Ref-Call
B) change to: select * from PUB."Ref-Call"
C) select * from PUB.references
D) change to: select * from PUB."references" 3) The SYSPROGRESS prefix is not specified for a SQL-92 system table or view.


Solution: Prefix the name of the table or view with SYSPROGRESS.


A) select * from systables
B) change to: select * from SYSPROGRESS.systables 4) The specified table,view, or synonym is not available in the current schema.


Solution: Prefix the object with the correct schema name or use the SET SCHEMA statement to change the current one.


set schema 'pub' 5) The specified table, view or synonym is not available in the database.


Solution: Use the correct object name, found in the database. Query the systables view for the object name.


select * from SYSPROGRESS.systables

or

select * from SYSPROGRESS.systables where tbl = 'customer'.