In the interface-specific database options table:
A hyphen (-) indicates that the database option has no default value. You can enter an appropriate value.
“Not available” indicates that the database option is not provided for the underlying interface.
“Not used” indicates that the database options is not used by the underlying interface, though it is displayed.
DB option |
Interface and default value |
Description |
|||||
|---|---|---|---|---|---|---|---|
Oracle |
ODBC/DB2 |
Sybase 15 |
Sybase |
OLEDB |
SQLite Persistent |
||
Always use logon credentials |
Not available |
0 |
Not available |
Not available |
Not available |
Not available |
When building the ODBC connection string, always add the credentials to the connection string. |
API trace |
Not available |
Not available |
False |
False |
Not available |
Not available |
Enable CTLIB trace facility. |
API version |
Not available |
Not available |
150 |
125 |
Not available |
Not available |
CTLIB API version compatibility. |
Auto vacuum |
Not available |
Not available |
Not available |
Not available |
Not available |
0 |
Reclaims the space when objects are deleted from the database. |
BLOB chunk size |
1024 While fetching LOB data from the file, ETL fetches 1024 bytes from the file and writes them to the database each time. |
Not available |
Not available |
Not available |
Not available |
Not available |
Determines the size at which LOBs are truncated. |
BLOB fetch mode |
LOB_ INLINE |
INLINE |
Not available |
Not available |
Not available |
Not available |
BLOB data is written either to the secondary file or held in the memory. If set to INLINE, data is held in memory. If set to FILE, data is written temporarily to the disk. |
Busy timeout |
Not available |
Not available |
Not available |
Not available |
Not available |
10 |
Creates a handler, which waits for the specified number of seconds on encountering a locked database table. |
Cache size |
Not available |
Not available |
Not available |
Not available |
Not available |
3000 |
Number of pages to use in cache. |
CLIENT_ CHARSET |
Not available |
Not available |
- |
- |
Not available |
Not available |
User defined character set to use with Client Library (CTLIB). |
CLIENT_ CONVERSION |
Not available |
Not available |
0 (ASE) 1 (ASA/IQ) |
0 (ASE) 1 (ASA/IQ) |
Not available |
Not available |
Controls whether or not the client library should convert data to the appropriate form. |
Connect timeout |
0 (Not used) |
0 (Not used) |
0 |
0 |
10 |
0 |
Stops trying to connect after the number of Connect timeout seconds. If set to 0, the connect does not timeout. |
CONVERTER_CHARSET |
Not available |
Not available |
- |
- |
Not available |
Not available |
The character set to be used when CLIENT_ CONVERSION = 1. |
Database name |
Not available |
Not available |
- |
- |
Not available |
Not available |
Database name. |
DBMS_VER |
Not available |
Not available |
- |
- |
Not available |
Not available |
Database version. |
Default cache size |
Not available |
Not available |
Not available |
Not available |
Not available |
3000 |
Default number of pages to use in cache. |
Disconnect timeout |
Not available |
10 On Windows 32-bit, ETL always uses the default value.On other platforms, this option is not used. |
Not available |
Not available |
Not available |
Not available |
Enforces disconnection from the database, if there is no reply from the database for n seconds after you try to disconnect. |
Enable SQL Server fast load |
Not available |
Not available |
Not available |
Not available |
1 |
Not available |
If set to 1, the MS SQL Server fast load feature is enabled. If set to 0, the feature is disabled. |
Execution timeout |
0 (Not used) |
0 /Not used |
-1 |
-1 |
Not available |
0 |
Component stops execution after a time interval in seconds. (0 <= means no timeout). |
Extended connect options |
Not available |
- |
Not available |
Not available |
- |
Not available |
Allows additional driver-specific parameters to be added to an ODBC connection string. |
Full column names |
Not available |
Not available |
Not available |
Not available |
Not available |
1 |
When set to 1, column names are fully qualified, following this pattern: <table-name/alias> <column-name>. |
Internal database |
Not available |
Not available |
Not available |
Not available |
Not available |
- |
Database reference. |
Isolation level |
DEFAULT (Not used) |
DEFAULT |
DEFAULT (Not used) |
DEFAULT (Not used) |
Not available |
DEFAULT (Not used) |
Defines the degree to which one transaction must be isolated from resource or data modifications made by other transactions. |
Lock resultset data |
0 (Not used) |
0 |
0 (Not used) |
0 (Not used) |
Not available |
0 |
Query tables will be locked ensuring that no data is written to the selected record set while the process is working on it. The selected record set is released when the last record from that set is fetched. |
Log SQL statements to a file |
0 |
0 |
0 |
0 |
0 |
0 |
If set to 1, all SQL statements are logged to the log or SQL.log file. |
Numeric support |
Not available |
0 This value is 0 rather than the user input, when DBMS is IQ or ODBC driver is ASA9. |
Not available |
Not available |
Not available |
Not available |
Whether or not to enable ODBC numeric support. |
Object name end quote |
" |
- ODBC uses the value queried from DBMS rather than the user input. |
] |
] |
- |
Not available |
When creating SQL statements, terminating character are used as quotes. |
Object name start quote |
" |
"" ODBC uses the value queried from DBMS rather than the user input. |
[ |
[ |
- |
Not available |
Beginning character to be used as quote when building SQL statements. |
PAD_BLANKS |
Not available |
Not available |
0 |
0 |
Not available |
Not available |
Maintains a constant column width using space characters. |
Page size |
Not available |
Not available |
Not available |
Not available |
Not available |
4096 |
Number of bytes per page. Must be a power of 2, greater than or equal to 512, and not higher than 32768. |
Quote character |
" |
Not available |
Not available |
Not available |
Not available |
Not available |
Same as QUOTE_START and QUOTE_END. |
Quote object names |
0 (Not used) |
0 |
0 |
0 |
0 |
0 |
If set to 1, the character specified in QUOTE_START and QUOTE_END is used to surround identifiers in generated SQL statements. |
Reject log column delimiter |
tab |
tab |
tab |
tab |
- |
tab |
Used as a column delimiter in the reject log. |
Short column names |
Not available |
Not available |
Not available |
Not available |
Not available |
0 |
If flag is set to false, column names are fully qualified, otherwise they are referred to only by the column name. |
Show all tables |
Not available |
Not available |
0 (Not used) |
0 (Not used) |
Not available |
Not available |
Display system tables as well as user tables. |
Show error location |
1 |
1 |
1 |
1 |
1 |
1 |
Display the error location if set to 1. Database errors include the position of the record within the result set. |
SHOW_ ERROR_ LOCATION_ ABSOLUTE_ ROWS |
1 |
1 |
1 |
1 |
1 |
1 |
Show the error location from the absolute begining of the result set, rather than the current result set. |
Synchronous |
Not available |
Not available |
Not available |
Not available |
Not available |
0 |
If you select Full =2, SQLite ensures data is written to disk before continuing. If you select Normal=1, SQLite pauses to write at critical moments but not as frequently as when set to 2. If you select Off = 0, data is handed off to operating system and SQLite continues. |
Temp store |
Not available |
Not available |
Not available |
Not available |
Not available |
2 |
If set to 1, the location of the temporary database is a file. If set to 2, the location of the temporary database is memory. |
Treat numeric value as character |
Not available |
1If database is IQ, or driver name contains “SYSYBNT” or “LIBDB2.A,”ODBC uses 1 instead of the user input. |
Not available |
Not available |
Not available |
Not available |
Force conversion of numeric data to string. |
Use system views |
True |
Not available |
Not available |
Not available |
Not available |
Not available |
Use DBA system tables to show metadata instead of per-user metadata. |
Validate result column binding |
Not available |
Not available |
Not available |
Not available |
1 |
Not available |
If set to 1, the result column mapping binding is validated when reading data from the database. |
Write empty dates as NULL |
0 |
0 |
0 (Not used) |
0 (Not used) |
Not available |
Not available |
If set to 1, the value of empty dates are enforced to be NULL. |
Write rejected records to file |
- |
- |
- |
- |
- |
- |
Specifies the file path for reject logs. This option is used to log records that are rejected by the database on loading. |
