Hey,
i have a set up a REST Connection and want to load data using a script in the data load editor:
The script looks like this:
LIB CONNECT TO 'RESTConnectionName';
LOAD
[Field1],
[Field2];
SQL SELECT
"Field1",
"Field2"
FROM CSV (header on, delimiter ",", quote """") "CSV_Source"
WITH CONNECTION (QUERY "name" "extraction_Name");
I´m looking for a way to give format specs, but i can´t see where this would fit using this syntax.
I want to tell it the encoding of the data for example using codepage is 65001, etc...
(I want to avoid using ApplyCodepage() on every field).
However it won´t let me put it in the options section right after "FROM CSV".
Does anyone know where i can specify this in the given syntax?
Greets