Up Prev Next
From: "Mark Aufflick" <mark at aufflick dot com>
Subject: OT: Sybase and Sequences (Was: Re: Retrieving Identity Value of newly inserted row)
Date: Jan 31 2006 11:43PM
Holy cow, you mean Sybase doesn't have sequences?! I've just recently
started a financial job (which means sybase it seems) and my db
background is mostly PostgreSQL with some Oracle and a smattering of
Is it just me, or is Sybase ASE missing some pretty obvious RDBMS
features and conveniences?
I know that this list is Sybperl specific, but the people here seem
pretty reasonable :) Can anyone recommend a good list/forum/community
where Sybase things are discussed? Eg. in this case, I would be
interested to read a discussion about sequence best practises.
On 1/1/1970, "Edward J. Sabol" wrote:
>> Work-around: don't use placeholders, or hack it with a SELECT
>> max(...) after the insert (ugh!)
>Or don't use identity columns. For implementing sequential keys, personally,
>I use "Method 3" as docummented at
>Placeholders work fine using this method.
> iBurst Wireless Broadband from $34.95/month www.platformnetworks.net
> Forward undetected SPAM to: firstname.lastname@example.org