BookmarkSubscribeRSS Feed
Citrine10
Obsidian | Level 7
ERROR: Error terminating Netezza load: NOTICE:  Rowset limit of 100000000 applied  : ERROR:  found binary 0 in a data field, 
       specify escapeChar '\' option in the external table definition

Getting this error when trying to join a dataset and library dataset as follows:

proc sql;
create table ConsolidatedCust as
select *
from Will t
left join ghom.customers c    /*this is the library*/
on t.Cin = c.cin
;quit;

1 REPLY 1
ballardw
Super User

I would say that sounds like a Netezza setting, possibly by the admins to keep accidentally large requests from processing.

Talk to the DB admins and see if this is the case and what settings you may need to have set for your access.

 

Also, it is good idea to include the entire text of the Errors and better to include the code that generated them. Copy the text with code, errors, notes, and messages for the problem call. Paste into a code box opened on the forum with the </> icon to preserve formatting. Errors often include diagnostic characters but the message windows on this forum will reformat text resulting in the characters appearing in the wrong place.

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 810 views
  • 0 likes
  • 2 in conversation