SVTABLE

The keyword SVTABLE is used to identify the relational database table that is used for the SQL select or insert operations.

The SVCOLUMN keyword is used to define the table columns.

Example

READ FILE(/folder/file.csv) SVTABLE(NEW_ORDERS) SVCOLUMN(ORDER)

 

SVFileServer.properties

sv.column.order=LINE_NUMBER,PART_NUMBER,PART_DESC,PART_AMOUNT,PART_QUANTITY