Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of bpendleton.derby@gmail.com
 designates 209.85.210.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:user-agent:mime-version:to:subject:references
         :in-reply-to:content-type:content-transfer-encoding;
        b=fqvlfBGzkkR1+b822jpVjkEwaUq54RDoTAo2kuh6d/Ve/pO1bX8jIxQp6XjcU6R2jZ
         cCiP5BUR2FIlDa2qIPdDCtooFzFDD+g3oBObSOYuseq/jWeu4N7eZc3eqTlUHLKidaPo
         LHgARdx/CAE6DBBPUJu+hgf0VrkgcCm5ofWEU=
Message-ID: <4DD3DBAB.4080308@gmail.com>
Date: Wed, 18 May 2011 07:46:03 -0700
From: Bryan Pendleton <bpendleton.derby@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
 rv:1.9.2.17) Gecko/20110424 Thunderbird/3.1.10
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: Autocounter/Sequqnce-Numbers
References: 
 <0773A3CE9DAC7B42B8F564C52805678D037A5003@EVS01.intern.interpay.nl>
In-Reply-To: 
 <0773A3CE9DAC7B42B8F564C52805678D037A5003@EVS01.intern.interpay.nl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 05/18/2011 07:05 AM, Malte.Kempff@de.equens.com wrote:
>  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.

Derby does support sequences:
http://db.apache.org/derby/docs/10.8/ref/rrefsqljcreatesequence.html

thanks,

bryan