SAPDB 7.3 Linux 2.4.20 working through JDBC driver (sapdbc.jar) the following statement produces the above error:
ALTER TABLE NOTIFICATIONS ADD CONSTRAINT FK_NOTIFICATIONS_STOCK FOREIGN KEY (FK_STOCK_ID) REFERENCES STOCKS (STOCK_ID) tried from various clients (sql tools, app servers, etc). the same problem persists if I copy&paste this query in websql. but the funniest thing is if i just switch to oracle mode in websql - it works smoothly without any changes (???!!). this doesn't apply to ansi, db2, and internal modes. so, where's the way out? the query was generated by app server, but it seems to be a standard ansi one, and worked for me on 2 other databases. your advice is appreciated. __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
