Hi, the solution is, that (instead of some other databases) it is not a SERIAL data type, it is a numeric datatype having a default value of the next SERIAL. So you may insert real values into these columns.
So a CREATE TABLE TEST (C1 INTEGER DEFAULT SERIAL) // INSERT INTO TEST VALUES (100) // INSERT INTO TEST VALUES (12) // INSERT INTO TEXT VALUES (DEFAULT) // will produce a table C1 --- 12 100 101 Regards Alexander Schr�der SAP Labs Berlin > -----Original Message----- > From: Hagen Schl�mer [mailto:[EMAIL PROTECTED] > Sent: Friday, February 28, 2003 11:19 AM > To: [EMAIL PROTECTED] > Subject: Upsize fom other DB-System > > > Hello! > > Is it possible to set the DataType "SERIAL" after exporting > data from a > third-party-product (like msaccess) I have to migrate my > databases, and i > can not redefine the row-id's of tables with > auto-increment-values. If the > new database is empty it is'nt a problem, but if i have to migrate the > existing data to sapdb via odbc it is a big problem. > > Any ideas? > Hagen > > > > _______________________________________________ > 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
