File Export from Table

Kalipso - Form - Actions - Actions Description - Group Files - File Export from Table

Export a local table to a text file.

Action available for the following operating systems:

Parameters

Data

  • Database Profile <unquoted string> - The name of the database profile to export.

  • File <string> - The full path and name of the file that the user wants to create with the exported data.

  • Encoding <unquoted string> - Indicates the file encoding to use.

  1. Unicode UTF-16 LE (each character uses 2 bytes)

  2. ANSI/BINARY (each character uses 1 byte)

  3. Unicode UTF-8 (each character uses 1 byte to 4 bytes)

  • If File Exists <unquoted string> - Defines what to do when the file already exists. The possible values are: Replace, Append or dynamic.

  • SQL <unquoted string> - The SQL code to export the data.

Details

  • Start of Record <unquoted string> - The string that identifies the start of the record in the text file.

  • End of Record <unquoted string> - The string that identifies the start of the record in the text file.

  • Field Separator <unquoted string> - The string separator for the elements between Start of Record and End of Record.

The last three details parameters are coded.

  • Decimal Separator <string> - Defines a string separator that is used to separate the numeric values.

Columns

  • Column <unquoted string> - The name of the table column where the data is exported.

  • Type <unquoted string> - The type of the data to be exported. The possible values are: String, numeric, Date, Time, Date Time or dynamic.

  • Mask <unquoted string> - Defines if the user wants to apply a mask to the exported values.

  • Length <numeric> - Defines the length of the exported data.

  • Decimal Separator <string> - Defines a string separator that is used to separate the numeric values.

  • Decimal Part Length <numeric> - Defines the length of the numeric part.

In Unicode UTF-16 LE, if the file does not exist or the Replace options is selected, the BOM (Byte Order Mark) 0xFEFF will be added to the beginning of the file. If the file already exists and the Append option is selected the first 2 bytes must be 0xFEFF.

In Unicode UTF-8, if the file does not exist or the Replace options is selected, no BOM (Byte Order Mark) will be added. If the file already exists and the Append option is selected the first 3 bytes may optionally be 0xEFBBBF.

The actions File Open and File Close don't need to be used.

Last updated