sybperl-l Archive

From: "Pablo Sanchez" <pablo at mew dot corp dot sgi dot com>
Subject: Re: sybperl bcp_meminit cannot handle dec()
Date: Mar 11 1996 5:43PM

On Mar 11,  9:51am, Michael Peppler wrote:
> Subject: Re: sybperl bcp_meminit cannot handle dec()
> > From: "Paul Shiao" 
> >
> >   I cannot bcp data into sybase SQLServer 10 because bcp_meminit() function
> >   does not know how to handle datatype dec, specifically dec(20,4).  Is
there
> >   a way to get around this bug?
> >
>
> The problem comes from not setting the DBlibrary version (ie calling
> dbsetversion()). This call enables System 10 features in DBlibrary
> which are turned off by default. In sybperl 2.03 and later, the
> dbsetversion() function is automatically called during intialization
> when sybperl has been built with DBlibrary version 10.x or later.
>
> You can get around this problem by adding
>
> 	dbsetversion(DBVERSION_100);
>
> in the DBlib.xs initialize() function, right after the call to dbinit()
> and re-build sybperl, or get the newer 2.03 or 2.04 versions.
>

It's imperative for SGI boxes to have dbsetversion() set as well... otherwise
things like dbcancel() won't work...



-- 
Pablo Sanchez              | Ph # (415) 933.3812        Fax # (415) 933.2821
pablo@sgi.com              | Pg # (800) 930.5635  -or-  pablo_p@corp.sgi.com
===============================================================================
I am accountable for my actions.   http://reality.sgi.com/pablo [ /Sybase_FAQ ]