Kbase P114274: Error (946) when attempting to remove a SQL89 table from the Database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/17/2006 |
|
Status: Unverified
FACT(s) (Environment):
Progress 8.x
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
Error (946) when attempting to remove a SQL89 table from the Database
** <user-name> is not the owner of <name>. (946)
Running a DROP TABLE statement in the 4GL Procedure Editor
Progress displays error (1649) when including the name of the user shown in the above error message in front of the table name within the DROP TABLE command
** You cannot make schema changes from SQL except on the DICTDB database. (1649)
The following error message is displayed when trying to delete the table from Data Dictionary
This is a PROGRESS/SQL table. Use DROP TABLE
The SQL-89 table was loaded into the database via the Data Administration's .df loader tool
The .df file used to load the data definitions does not contain a CAN-CREATE line for the offending table
The value of _File._Can-read for the loaded SQL-89 table is set to asterisks (*)
Progress shows error (1011) when programmatically trying to update the value of _File._Can-read using the 4GL
** SQL table <name> can be modified only through SQL DDL statements. (1011)
CAUSE:
This is a known issue being investigated by Development
FIX:
Before loading the .df file into the Database, manually modify it by adding the following line under the ADD TABLE section for the offending table:
CAN-CREATE "<username-currently-logged-into-the-4GL>,*"
The name of the user in the above line is the same as the one that is coming up within the 946 error message