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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: