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;
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.
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.
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.