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 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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