sybperl-l Archive

From: michael dot peppler at bnpparibas dot com
Subject: Re: OT: Sybase and Sequences (Was: Re: Retrieving Identity Value of newly inserted row)
Date: Feb 1 2006 7:12AM

No, Sybase doesn't have sequences (AFAIK neither does MS-SQL).
Sybase has identity columns, and then you can write your own sequence 
generators using stored procs, or whatever method you want to use.

There's a good write up on the various methods at 
http://www.sybase.com/detail?id=860 (the document is 8 years old, but it's 
still valid for the most part).

To get more information I would recommend the newsgroups at 
news://forums.sybase.com (in particular the sybase.public.ase.* groups). 
Lots of Sybase engineers and various other highly competent people read 
these groups and help out.

The sybase-l mailing list hosted by ISUG (International Sybase User Group) 
is good (go to www.isug.com to subscribe to the list).

Michael




Internet
mark@aufflick.com@peppler.org - 01/02/2006 00:43
 
Sent by:        owner-sybperl-l@peppler.org
To:     sabol, Robert_Gorrebeeck, sybperl-l
cc: 
Subject:        OT: Sybase and Sequences (Was: Re: Retrieving Identity 
Value of newly inserted row)



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
MySQL.

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.

Cheers,

Mark.

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
>
>http://www.isug.com/Sybase_FAQ/ASE/section6.2.html#homegrown
>
>Placeholders work fine using this method.
>
>========================================================================
> iBurst Wireless Broadband from $34.95/month   www.platformnetworks.net
> Forward undetected SPAM to:                   spam@mailsecurity.net.au
>========================================================================
>


This message and any attachments (the "message") is
intended solely for the addressees and is confidential. 
If you receive this message in error, please delete it and 
immediately notify the sender. Any use not in accord with 
its purpose, any dissemination or disclosure, either whole 
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message. 
BNP PARIBAS (and its subsidiaries) shall (will) not 
therefore be liable for the message if modified. 

                ---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le 
"message") sont etablis a l'intention exclusive de ses 
destinataires et sont confidentiels. Si vous recevez ce 
message par erreur, merci de le detruire et d'en avertir 
immediatement l'expediteur. Toute utilisation de ce 
message non conforme a sa destination, toute diffusion 
ou toute publication, totale ou partielle, est interdite, sauf 
autorisation expresse. L'internet ne permettant pas 
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce 
message, dans l'hypothese ou il aurait ete modifie.