When you use an ODBC Library that is assigned to a Netezza database, using a DATA Step to write from SAS to the database management system (DBMS) might return an error similar to the following:

libname mydata odbc dsn=nzsql;

data test;
format tenants 20.0;
tenants=50.1; output;
run;

proc delete data=mydb.test; run;
data mydb.test; 
set test; 
run;


ERROR: CLI execute error: Operation canceled : ERROR:  External Table : count
       of bad input rows reached maxerrors limit

Workarounds

To work around this issue, do the following:

• Modify the column or create a column format so that the created table and corresponding column precision accept the data value. Here is an example:

     
  data test;
     format tenants 20.1;
     tenants=50.1; output;
  run;
  

• Modify the data so that it does not have a decimal or an integer, or else modify it so that the decimal is zero. This example shows the latter:

data test;
   format tenants 20.0;
   tenants=50.0; output;
run;

Operating System and Release Information