Kbase P183403: Getting errors 10713 or 7519 when trying to access Virtual System Tables (VST)s via SQL statements.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/03/2011 |
|
Status: Unverified
SYMPTOM(s):
Getting errors 10713 or 7519 when trying to access Virtual System Tables (VST)s via SQL statements.
SQL Statements used that result in the 10713 error:
select * from PUB._AreaStatus
SQLState=HY000
ErrorCode=-210056
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Syntax error in SQL statement at or about "_AreaStatus" (10713)
SQL Statements used that result in the 7519 error:
select * from "PUB._AreaStatus"
SQLState=42S02
ErrorCode=-20005
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Table/View/Synonym not found (7519)
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
The problem is that the Virtual System Table (VST) name is missing double quotes to negate the "_" underscore character.
FIX:
Add double quotes around the Virtual System Table (VST) name.
Example:
SELECT * from PUB."_AreaStatus";