Noah Silva wrote : >Hi,
>I am running SAPDB 74[.0.14?] on windows 2000, the DB type is OLTP. I am >accessing the DB in internal mode. >I have a table, which contains a column like: >NAME TYPE DEFAULT >-------------- ---------------- ---- >DEGREE SMALLINT 64 >There are quite a few other columns, mainly Boolean and integer, with a >few short CHAR and VARCHAR. >I tried to rename DEGREE to STRENGTH in SQL Studio, and when I select >execute, I get an error dialog: >"Database Error Occurred: >Native Error: -9406 >Text: [SAP AG][SQLOD32.DLL][SAP DB]General Error; -9406 DDL Trigger failed >: 200." SQL Studio maintains some system tables, which contain some meta data about your tables. When you rename a table column, these tables have to be updated. This happens via a system trigger which is implicitly fired after the column has been renamed. The error -9406 means that this trigger could not be executed successfully. Without further information I can't tell you what's going on. Maybe you can send me a vtrace containing a trace of the problem (see http://sapdb.2scale.net/moin.cgi/VTrace). As a workaround you may disable the triggers via "dbmcli -d <dbname> -u <user,pwd> util_execute diagnose trigger off". Regards, Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
