Hello,
First post... I am a new SAS user, and am trying to connect using ODBC...I can use a LIBNAME statement to connect via ODBC, and I can see the data tables, view the records, etc., however, when I use a DATA statement to pull the data in, it will read all of the data in, and then throw this error:
ERROR: CLI cursor extended fetch error: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0501
- Cursor SQL_CUR0ABB58E0 not open.
Any idea what I am perhaps doing wrong or have configured incorrectly? Thank you.
Are you accessing a table or a view?
Can the view successfully execute on the server side?
Here is the code I try to execute (password replaced)
LIBNAME PROD ODBC USER = 'mperva' PASSWORD = 'XXXXXXX' DATAsrc='Production' SCHEMA = 'OLYDBF';
DATA TEST;
SET PROD.IDCS;
RUN;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.