Connector Framework Server 12.11

# SqlWriterFieldNamesN

The names of the document fields that you want to include in the SQL insert statements created by the task. The fields that you specify are inserted into the columns specified by the corresponding `SqlWriterColumnNamesN` parameter.

- To specify a field, type the field name.
- To specify a sub-field, type the field name, followed by a forward slash, followed by the name of the sub-field.
- To specify a field attribute, type the field name, followed by a forward slash, followed by the name of the attribute. Prefix the attribute name with the '`@`' character.

The `SqlWriter` task always includes the `DREREFERENCE` and `DRECONTENT` document fields. Specify the columns that receive these values by using the `SqlWriterDreReferenceColumnName` and `SqlWriterDreContentColumnName` parameters.

If you specify a field that has multiple values, the `SqlWriter` task writes only the first value.

Type: | String
Default: |
Required | Yes
Configuration Section: | Any section you have defined for `SqlWriter` task settings
Example: | `SqlWriterFieldNames0=documentField SqlWriterColumnNames0=tableColumn SqlWriterDataTypes0=CHAR SqlWriterFieldNames1=documentField/subField SqlWriterColumnNames1=subFieldColumn SqlWriterDataTypes1=INT` In this example, the data from the document field "documentField" is written to the column "tableColumn", and the data from the subfield "subField" is written to the column "subFieldColumn".
See Also: | SqlWriterColumnNamesN SqlWriterDataTypesN SqlWriterDreReferenceColumnName SqlWriterDreContentColumnName

© Copyright 2022 Micro Focus or one of its affiliates
Version 12.11 | Last updated February 2022

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to swpdl.idoldocsfeedback@microfocus.com.

We appreciate your feedback!

Product: IDOL Connector Framework Server 12.11

Topic Title: SqlWriterFieldNamesN