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