SQL File Export
Parameters
Name | Mandatory | Default | Description |
---|---|---|---|
SQL Exp File Append |
No |
false |
Set to true to append the result of the query to the existing file. Otherwise, overwrite the existing file. |
SQL Exp Generate Header |
No |
false |
Adds a header line containing the line of fields at the beginning of the file. |
SQL Exp Boolean As Numeric |
No |
true |
Boolean values |
SQL Exp Row Sep on Last Row |
No |
false |
A row separator is added after the last row. |
SQL Exp Row Sep On First Row When Append |
No |
true |
If SQL Exp File Append is set to true, then a row separator is added before the first row. |
SQL Exp Generate If Empty |
No |
false |
Writes the file even if the query returns no record. |
SQL Exp Add Record Number |
No |
false |
Adds a record number at the beginning of each row. |
SQL Exp Absolute Numeric |
No |
false |
Use absolute numeric values. |
SQL Exp Use Numeric Grouping Char |
No |
false |
Use digit grouping and the digit grouping symbol. |
SQL Exp Enclose All Fields |
No |
false |
The SQL Exp String Delimiter is applied on all the fields. |
SQL Exp Filename |
Yes |
Full path to the output file. |
|
SQL Connection |
No |
SQL connection used for the query. This connection is automatically set on the action if a metadata link is added on this action. |
|
SQL Transaction Name |
No |
SQL transaction name used for the query. |
|
SQL Exp SQL Query |
No |
Query to execute. This query should return records. Alternately, you can provide this query in the action’s code or in a SQL Exp SQL Query File. |
|
SQL Exp SQL Query File |
No |
File containing the query to execute. This query should return records. Alternately, you can provide this query in the action’s code or in the SQL Exp SQL Query parameter. |
|
SQL Exp SQL Query File Encoding |
No |
System’s encoding |
Encoding of the file containing the query to execute. |
SQL Exp Named Object |
No |
Named object to export to the file. Use this parameter instead a SQL Query to export the named object content instead of the SQL Query resultset. |
|
SQL Exp File Format |
No |
variable |
Format of the output file: variable (delimited file) or positional (fixed width). |
SQL Exp Row Sep |
No |
System’s line break |
ASCII row separator. It may be composed of several characters. \n, \r, \t and \f can be used to specify special characters. |
SQL Exp XRow Sep |
No |
Hexadecimal row separator. It may be composed of several characters. |
|
SQL Exp Field Sep |
No |
``;'' |
ASCII field separator for a variable file. It may be composed of several characters. \n, \r, \t and \f can be used to specify special characters. |
SQL Exp XField Sep |
No |
Hexadecimal field separator for a variable file. It may be composed of several characters. |
|
SQL Exp String Delimiter |
No |
ASCII character used to delimit strings in a variable file. |
|
SQL Exp XString Delimiter |
No |
Hexadecimal character used to delimit strings in a variable file. |
|
SQL Exp Numeric Separator Char |
No |
System |
Decimal Symbol. |
SQL Exp Numeric Grouping Char |
No |
System |
Digit grouping symbol. This symbol is used for example to group thousands, millions, etc. |
SQL Exp Numeric Pad Char |
No |
Space |
Character used to left-pad numbers in case of a positional file. |
SQL Exp String Pad Char |
No |
Space |
Character used to right-pad strings in case of a positional file. |
SQL Exp Date Format |
No |
yyyy/MM/dd HH:mm:ss.SSS |
Format for date fields. By default, the Runtime engine configuration value if used. |
SQL Exp Short Date Format |
No |
Format for date fields. By default, the Runtime engine configuration value if used. There is no default value. If not specified, the default value will be the same as the Date Format parameter. |
|
SQL Exp String Delimiter Replacement |
No |
ASCII character used to delimit strings for input data. |
|
SQL Exp Fetch Size |
No |
1000 |
Fetch size (number of lines). By default, the Runtime engine configuration value if used. |
SQL Exp File Buffer Size |
No |
8192 |
File buffer size in octets. |
SQL Exp Max File Size |
No |
–1 |
Maximum size of the files to generate. This size is expressed in octets, but can also be expressed in other units: for example 64K, 5M, 1G. –1 stands for no size limit. If this parameter is set, the action will automatically chunk the data into files of this size, suffixing the file names with an increment starting with 1. |
SQL Exp Local Language |
No |
System |
Language used for writing the file. The default value is the system value for the Runtime engine. The language impacts the characters used, for example the character for the decimal separator. |
SQL Exp File Encoding |
No |
System’s encoding |
Encoding used for the file. |