Hi,
I want to use my R-client to insert csv in a database.
These lines works:
csv_add_run <- 'RUN "./DataScience/RBaseX/CSVexample.xq"' Session$command(csv_add_run)
When I take the content from CSVexample.xq and incorporate that into a EXECUTE command, I get this:
csv_add_exe <- 'EXECUTE "let $root := '/home/bengbers/DataScience/RBaseX/Examples/Parse/;)'; for $path in file:children($root)[ends-with(., '.csv')] return db:add('CSV_test', $path, 'CSV_API', map { 'parser': 'csv', 'csvparser': map { 'header': 'yes', 'separator': ';' }) "'
Session$command(csv_add_exe)
Stopped at , 1/9: Unknown command: 'EXECUTE. Did you mean 'EXECUTE'?
My question is how to define the input for the EXECUTE-command?
Cheers, Ben