System details
RStudio Edition : Desktop
RStudio Version : 1.2.1511
OS Version : Windows 7
R Version : 3.6.0
I am connecting my organisation's database using Sybase IQ as well as RStudio via ODBC connection.
I can export SQL results to a csv file in Interactive SQL app with the following codes
select top 10* into #test from DATA;
select * from #test;
output to "E:\\test.csv";
However, neither output to nor into outfile (in some other suggestions) works via RStudio's SQL engine.
Is there anyway I can achieve this?