SqlWriterDataTypesN

The data type of the column specified by the corresponding SqlWriterColumnNamesN parameter.

You can specify one of the following data types:

  • SHORT
  • INT
  • UNSIGNED_INT
  • BIG_INT
  • FLOAT
  • DOUBLE
  • CHAR
  • DATE_TIME
  • RAW
Type: String
Default:  
Required Yes
Configuration Section: Any section you have defined for SqlWriter task settings
Example:

SqlWriterFieldNames0=documentField
SqlWriterColumnNames0=tableColumn
SqlWriterDataTypes0=CHAR

In this example, the value of the document field "documentField" is written to the column "tableColumn" using the "CHAR" data type.

See Also:

SqlWriterFieldNamesN

SqlWriterColumnNamesN