Connector Framework Server 24.4
IDOL Connector Framework Server Help

# 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 2024 Open Text
Version 24.4 | Last updated September 2024

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 MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: IDOL Connector Framework Server 24.4

Topic Title: SqlWriterFieldNamesN