After reading the article on number generators I'm stuck in a "somewhere between situation" I need to convert a lot of tables from oracle to sapdb that have a automatic number generator in oracle based on a trigger BEFORE insert and a sequence. Serial data type seems to be what I need, BUT: can i make the number generator start from a certain number other than 1 and can I temporarly suspend the number generation until all the tables are converted. Because the existing numbers have so much references to other table, it is practically impossible to regerenate them with the new numbers starting from 1. If that is not possible, how can I use a combination of triggers and sequences in sapdb to simulate the same effect, WITHOUT the need to specify myseq.NEXTVAL in my queries. Because our client programs are not written to do that, and that would mean a lot of work to adjust that. According to the docs, the trigger is triggered AFTER an insert. so what are my options here?
Greets, Filip Sergeys -- *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* * System Engineer, Verzekeringen NV * * www.verzekeringen.be * * Oostkaai 23 B-2170 Merksem * * 03/6416673 - 0477/340942 * *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
