SVTABLE

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(order.csv) SVTABLE(NEW_ORDERS) SVCOLUMN(ORDER)

 

Example SVFileService.properties

 

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