Create External File Type and Template from View
Explanation
Use this activity to create an external file type definition and if requested
an external file template definition from a view.
This is very useful when you want to use the External Files toolkit to produce
an output file by reading data from a view in the Cloud. This is achieved by
doing the following:
- Use this create activity to create both an external file and an external
template definition.
- Use the External
File Assistant to create the output file by referring to the
created file type and file template.
- Use the New File Type and File Template from View Definition
command from the External File Types page to perform
this activity.
Prerequisites
You will not be able to select a view that you're not privileged to use.
System Effects
The create process will create the following:
- An external file type header.
- One record type definition along with column definitions for that record
type.
- Available external file parameters.
- One or two parameter sets for the file type depending on create criteria.
- Available parameters per set definition with default value defined for
the parameter FILE_DIRECTION_DB to distinguish the input and output parameter
sets from each other.
- An external file template header defined as a template to handle character
separated values in a file.
- External template details corresponding to the record type and column
definitions for the external file type.
- Template definitions for input and/or output files depending on create
criteria.