Kbase P92401: SQL92 schema table (table ) can be written, modified, or deleted only from SQL92. (6546)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/23/2004 |
|
Status: Unverified
SYMPTOM(s):
SQL92 schema table (table <table name>) can be written, modified, or deleted only from SQL92. (6546)
Attempting to update an SQL-92 schema table using 4GL code simpilar to:
FIND FIRST _systabauth.
ASSIGN
_systabauth._grantor = "somestring".
CAUSE:
There are several schema tables which are maintainable only from SQL92 product components via SQL DDL capabilities. These SQL92 schema tables cannot be written to from the 4GL.
FIX:
Do not attempt to mdoify SQL-92 schema tables using 4GL.