Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

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