Open topic with navigation

# 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 2018 Micro Focus or one of its affiliates | Send documentation feedback Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a web mail client, and send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm