Element Details: Oracle+Custom+Control+File
 Back


Available in: Logi Info Source code name: OracleCustomControlFile

Normally you will not need to use this element since ETL automatically generates an Oracle control file based on the information provided by the LoadDbTable.Insert element.

Use this element to replace the automatically generated file with your custom control file. The custom control file provided will be passed to Oracle's SQL*Loader for processing.

This element is only used if the LoadDbTable.Insert attribute Insert Method is set to bulk.



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
CustomControlFileText
UserDefined
(Required) The text of the Oracle control file. In addition to the standard Logi tokens, the following custom tokens are also available. The values for these tokens are automatically defined based on the attribute values of your LoadDbTable.Insert element. @Etl.BulkDataFile~ = Full name of the dat file to import. @Etl.BulkErrorFile~ = Full name of the error file. @Etl.BulkTableName~ = Table name to insert into. @Etl.BulkFieldDelimiter~ = Field delimiter. @Etl.BulkRowDelimiter~ = Row delimiter. @Etl.BulkTextQualifier~ = Text qualifier. Example: Load Data CHARACTERSET UTF8 InFile '@Etl.BulkDataFile~' BadFile '@Etl.BulkErrorFile~' Append Into Table @Etl.BulkTableName~ Fields Terminated by '@Etl.BulkFieldDelimiter~' Optionally Enclosed by '@Etl.BulkTextQualifier~' TRAILING NULLCOLS ( )
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.



PARENT ELEMENTS

Click element to drill down for more information.

Load DB Table.Insert


CHILD ELEMENTS

Click element to drill down for more information.



 Back to top