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

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.

SQL Exp File Append

false

Set to true to append the result of the query to the existing file. Otherwise, overwrite the existing file.

SQL Exp Generate Header

false

Adds a header line containing the line of fields at the beginning of the file.

SQL Exp Boolean As Numeric

true

Boolean values true/false'' are converted to1/0''.

SQL Exp Row Sep on Last Row

false

A row separator is added after the last row.

SQL Exp Row Sep On First Row When Append

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

false

Writes the file even if the query returns no record.

SQL Exp Add Record Number

false

Adds a record number at the beginning of each row.

SQL Exp Absolute Numeric

false

Use absolute numeric values.

SQL Exp Use Numeric Grouping Char

false

Use digit grouping and the digit grouping symbol.

SQL Exp Enclose All Fields

false

The SQL Exp String Delimiter is applied on all the fields.

SQL Exp Filename

Yes

Full path to the output file.

SQL Connection

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

SQL transaction name used for the query.

SQL Exp SQL Query

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

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

System’s encoding

Encoding of the file containing the query to execute.

SQL Exp Named Object

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

variable

Format of the output file: variable (delimited file) or positional (fixed width).

SQL Exp Row Sep

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

Hexadecimal row separator. It may be composed of several characters.

SQL Exp Field Sep

``;''

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

Hexadecimal field separator for a variable file. It may be composed of several characters.

SQL Exp String Delimiter

ASCII character used to delimit strings in a variable file.

SQL Exp XString Delimiter

Hexadecimal character used to delimit strings in a variable file.

SQL Exp Numeric Separator Char

System

Decimal Symbol.

SQL Exp Numeric Grouping Char

System

Digit grouping symbol. This symbol is used for example to group thousands, millions, etc.

SQL Exp Numeric Pad Char

Space

Character used to left-pad numbers in case of a positional file.

SQL Exp String Pad Char

Space

Character used to right-pad strings in case of a positional file.

SQL Exp Date Format

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

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

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

ASCII character used to delimit strings for input data.

SQL Exp Fetch Size

1000

Fetch size (number of lines). By default, the Runtime engine configuration value if used.

SQL Exp File Buffer Size

8192

File buffer size in octets.

SQL Exp Max File Size

–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

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

System’s encoding

Encoding used for the file.