Having a problem with getting data from a SalesForce table called Case.
The error is as below.
This happens when I try to set the table or submit a query with a pass-through.ERROR: CLI describe error: [Devart][ODBC][Salesforce]You have an error in your SQL syntax at line 1, column 15: Unexpected symbol 'case'
Code: Select all
libname sforce odbc dsn='saleforce' user = 'username' password = 'password';
data case;
set sforce.case;
run;
proc sql;
connect to odbc as salesforce (dsn='salesforce' user = 'username' password = 'password');
create table t01 as select * from connection to salesforce(
select * from Case;
disconnect from salesforce;
quit;
I believe it occurs because 'case' is an sql keyword.