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