Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C86A569A4 for ; Wed, 18 May 2011 14:06:08 +0000 (UTC) Received: (qmail 71517 invoked by uid 500); 18 May 2011 14:06:08 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 71478 invoked by uid 500); 18 May 2011 14:06:07 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 71471 invoked by uid 99); 18 May 2011 14:06:07 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 18 May 2011 14:06:07 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [82.195.46.59] (HELO smtp01.equens.com) (82.195.46.59) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 18 May 2011 14:06:00 +0000 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01CC1564.A58B147C" X-MimeOLE: Produced By Microsoft Exchange V6.5 Subject: Autocounter/Sequqnce-Numbers Date: Wed, 18 May 2011 16:05:30 +0200 Message-ID: <0773A3CE9DAC7B42B8F564C52805678D037A5003@EVS01.intern.interpay.nl> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Autocounter/Sequqnce-Numbers Thread-Index: AcwVZKV/hzb8tOhjQcSdD809RTM6IQ== From: To: X-OriginalArrivalTime: 18 May 2011 14:05:30.0669 (UTC) FILETIME=[A5A245D0:01CC1564] X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------_=_NextPart_001_01CC1564.A58B147C Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi to all, in http://www.h2database.com/html/features.html#feature_list I found this particular statement to above topic: =20 Sequence and autoincrement columns, computed columns (can be used for=20 function based indexes) =20 Later on is a matrix that shows some RDBMs in releation to some features where it is denied that Derby supports sequences. =20 So what is actually the case? And if Derby supports running numbers (in Oracle they are called sequences, in Microsoft DBs the are often called auto counters) how are they to be used. =20 Thanks in advance for any hint =20 Malte ------_=_NextPart_001_01CC1564.A58B147C Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi to all,

in http:/= /www.h2database.com/html/features.html#feature_list I found this particular statement to above = topic:

 

Sequence and = autoincrement columns, computed columns (can be used for
function based indexes)

 

Later on is a matrix that shows some RDBMs in = releation to some features where it is denied that Derby supports sequences.

 

So what is actually the case? And if Derby supports running numbers (in = Oracle they are called sequences, in Microsoft DBs the are often called auto = counters)  how are they to be used.

 

Thanks in advance for any = hint

 

Malte

------_=_NextPart_001_01CC1564.A58B147C--