|
|
sybperl-l Archive
Up Prev Next
From: Doug Fairclough <kensey at wired dot com>
Subject: Re: Sybperl question
Date: Jan 19 1996 12:59AM
dont use IDENTITY ! they SUCK ! rebuild youree table without them,
using an int field that you control the incremental of.
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
> ----------------------------------------------------------------------
>
|
