Sven K�hler wrote: >hi,
>i just got a shock while reading: >http://www.sapdb.org/how_tos/numbergen/howto_producenumgen_eng.htm >The use of a CREATE SEQUENCE is very complicated, as i have to use one >sequence per Table, or one for the whole database, which makes the >number grow very fast. I also have to use the Sequence on every INSERT >statement (and i cannot be sure, that the value of the column doesn't >change, right?) >The other option is, to use DEFAULT SERIAL which was my favourite, until >i read, that i cannot get the value that was used. I would recommend datatype SERIAL, i.e. CREATE TABLE TEST (S SERIAL, ... >Is this solved in SAPDB 7.3? >Is a patch planned? With the next SAPDB version you can get the last serial value via the currval function specifying the table name, i.e. SELECT TEST.CURRVAL INTO ? FROM SYSDBA.DUAL; or easier in a db-procedure VAR currVal integer; currVal = TEST.CURRVAL; >Is it solved in v7.4? >when will it be released? 7.4 will have the same behavior. 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
