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