Contents
Display Legacy Contents

 Print
    File Export from Table    
Export a local table to a text file.

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. This parameter is coded.
   
  End of Record <unquoted string>: the string that identifies the start of the record in the text file. This parameter is coded.  
   
  Field Separator <unquoted string>: the string separator for the elements between Start of Record and End of Record. This parameter is 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.

 
  (...) 
   
  Nth-Column <unquoted string>: the nth-name of the table column where the data is exported. 
   
  Nth-Type <unquoted string>: the nth-type of the data to be exported. The possible values are: String, numeric, Date, Time, Date Time or dynamic. 
   
  Nth-Mask <unquoted string>: defines if the user wants to apply a mask to the nth-exported values. 
   
  Nth-Length <numeric>: defines the nth-length of the exported data. 
   
  Nth-Decimal Separator <string>: defines a nth-string separator that is used to separate the numeric values. 
   
  Nth-Decimal Part Length <numeric>: defines the nth-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.

See also
Samples

 

 

Updated: 5/30/2018 4:10 PM