The following snippet can be used with Data Virtuality Server 2.0.
We assume the the FTP / SFTP server is already used as a data source in Data Virtuality. Therefore we can use the FTP data source directly as the target schema.
call "UTILS.csvExport"(
"sourceSchema" => '<sourceSchema>',
"sourceTable" => '<sourceTable>',
"targetSchema" => '<NameOfFTPdatasource>',
"targetFile" => '<targetFile>',
"delimiter" => '<delimiter>',
"quote" => '<quote>',
"header" => <trueORfalse>,
"orderBy" => 'string_orderBy',
"encoding" => '<encoding>'
);;
The following parameters can be deleted if not used:
- targetFile
- delimiter
- quote
- header
- order by
- encoding
