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
  • No labels