PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Gisle Aas <aas at bergen dot sn dot no>
Subject: Re: Sybperl question
Date: Jan 19 1996 10:59AM

Doug Fairclough wrote:
> dont use IDENTITY !  they SUCK !  rebuild youree table without them,
> using an int field that you control the incremental of.

Can you explain why and how much they suck?

We have just started with a major project and we use IDENTITY on several 
tables.  We would really like to know if we better not.

Regards,
Gisle Aas



> On Thu, 18 Jan 1996, Ivan Simon wrote:
> 
> > I have a question about sybperl.
> > 
> > Sometimes Sybase generates IDENTITY numbers that are very large,
> > 18 digits long. This is too long for sybperl and perl to handle
> > as an integer and so they are converted to exponential notation
> > when they are returned from sybase to perl throught sybperl.
> > 
> > I would like to catch these values as strings on the perl side
> > without changing the sybase stored procedure that returns them.
> > (Do a convert(varchar(20),inst_id) in the stored procedure).
> > 
> > Any suggestions as to how I can do this.
> > 
> > Thanks,
> > 
> > Ivan.
> > 
> > -- 
> > ----------------------------------------------------------------------
> > Ivan Simon.
> > Algorithmics Incorporated, 822 Richmond St. W., 3rd Floor.
> > Toronto, Ontario, Canada, M6J 1C9.
> > TEL: (416)703-0898 ext. 242, FAX: (416)703-0767, ivan@algorithmics.com
> > ----------------------------------------------------------------------
> >