Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile
• My SAS

• Print  |
• Feedback  |
• Share

  • E-mail
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

Errors may be issued when attempting to insert data into SYBASE using
the DOLLAR 12.2 format.

USING BULKLOAD the following error is issued:

   ERROR: Bulk Data Transfer Failed: Error Code: 0 blk_rowxfer():
          blk layer:  internal BLK-Library

   error: Failed in conversion routine - condition overflow.
          col = 71 row = 196.


WITHOUT BULKLOAD the following error is issued:

   ERROR: Error in results set for Insert. Error Code: -247 Arithmetic
          overflow during implicit conversion of FLOAT value '235000.0'
          to a SMALLMONEY field .

Executing the following SAS code produces an overflow error:

   libname x sybase user=dbitest password=dbigrp1 server=lost119;

   data data.dollar;
   format col1 dollar12.2;
   col1=235000.00; output;
   run;

   proc delete data=x.dollar; run;
   data x.dollar (bulkload=yes dbnull=_all_=yes);
   set data.dollar;
   run;

This is bug with BULK COPY and standard output processing.

A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#005897

Operating System and Release Information

A fix for Release 8.2 (TS2M0) for this issue is available at: