SQL File Export

RdbmsExport32x32

Description

Exports the result of a SQL query or a named object to a flat file.

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 true/false'' are converted to 1/0''.

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

The pattern used for datetime and timestamp related source columns. The pattern can contain both date (E.g. yyyy/MM/dd) and time information (E.g HH:mm:ss.SS).

SQL Exp Short Date Format

No

The pattern used for date related source columns. The pattern can contain only date information (E.g. yyyy/MM/dd). If you include time information in the pattern, as the source data does not contain this information, the time part will be defined automatically to midnight. If this parameter is not specified, the default value will be the same as the SQL Exp Date Format.

SQL Exp Time Format

No

The pattern used for time related source columns. The pattern can contain only time information (E.g HH:mm:ss.SS).

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.