sybperl-l Archive

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