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: bcp_meminit does not handle decimal(p,s) datatype correctly
Date: Mar 11 1996 11:07AM

> From: "Paul Shiao" 
> 
>   I have a script (bcp_bug.pl) which bcp data (in table test.dat) into 2 
>   tables:  float_table(one int, two float)
>            dec_table(one int, two dec(20,4))
>   
>   If you retrieve the data you will notice the dec_table.two does not have the 
>   expected data.  (the results are stored in test.log)  I believe the cause is 
>   that bcp_meminit() function does not correctly handle decimal() datatype.  
>   Is there a fix for this bug?

The data gets uploaded correctly if sybperl enables the System 10
behavior of DBlibrary via the dbsetversion() call.

Sybperl 2.03 and later call this function automaticaly when sybperl is
built with DBLIBVS >= 1000, but you can add
    dbsetversion(DBVERSION_100);
right after the call to dbinit() in the initialize() function in
DBlib.xs if you wish to enable this behavior in your current copy of
sybperl.

Michael