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

© 2016 Hewlett Packard Enterprise Development LP | Send documentation feedback to HPE Close We welcome your comments! 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 AutonomyTPFeedback@hpe.com. Product: Topic Title: Help Topic: Feedback:

_HP_HTML5_bannerTitle.htm