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

Reply via email to