Thomas Rohn wrote: > Hi, > I put on this table > CREATE TABE Document > ( > Vorname CHAR (10), Nachname CHAR (20), StatusInfo CHAR > (20), Autor CHAR (30), Datum INT (10) > ) > > INSERT INTO Document VALUES > ( > 'Thomas', 'Rohn', 'Bearbeitung', 'tr', 17032003 > ) > > Error Message: Native error: -20
You are using sqlmode ANSI or DB2, oops, not very common. -20 is the same as +200: duplicate key. For these two sqlmodes the positive returncodes are changed (only negative ones are specified to be allowed as errorcode). They are changed in the way +xyz --> -(xyz DIV 10) You did not tell us all about your table, did you? There is a primary key on that table or there is an insert-trigger inserting/updating another table resulting in that error. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
