sybperl-l Archive

From: mpeppler at itf dot ch (Michael Peppler)
Subject: Re: sybperl bcp_meminit cannot handle dec()
Date: Mar 11 1996 8:51AM

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

Michael