mohan wrote : >hai > I first would like to thank all others who have responded to >my earliar mail about CLOB,BLOB and gave me a solution especially >Mr > > I am stuck up with another problem I am not able to add >constraints to the table after creating table sucessfully The >oracle query I have is :
>ALTER TABLE tab1 ADD CONSTRAINT tab1_constr_tab2 >FOREIGN KEY(col1_tab1) >REFERENCES staff(col1_tab2) >Please let me know the equivalent query in sapdb >(The error displayed for above query is "Invalid end of SQL >statement") > Your alter table statement will work, if you connect in sqlmode oracle. If you're connected in sqlmode SAPDB, please use the following syntax : ALTER TABLE tab1 ADD FOREIGN KEY(col1_tab1) REFERENCES staff(col1_tab2) 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
