Dear Community, I was using SAS EG to pull data from a Netezza database using below code: proc sql outobs=10; connect to odbc(dsn=Netezza_PROD uid=xxxxx password = xxxxx); * Retail Deposit; create table test as select * from connection to odbc( select * from database.dbadmin.table ); disconnect from odbc; quit; I got this error "ERROR: CLI cursor fetch error: Numeric value out of range". I found the answer in this post is helpful https://communities.sas.com/t5/SAS-Programming/quot-CLI-cursor-extended-fetch-error-Numeric-value-out-of-range/td-p/323830 But in my case, I have lots of variables and it's hard to check which variable is the issue one.. Need your help please. Thanks.
... View more