DB Option |
Interface and default value |
Description |
|||||
|---|---|---|---|---|---|---|---|
Oracle |
ODBC/DB2 |
Sybase 15 |
Sybase |
OLEDB |
SQLite Persistent |
||
Allow fallback |
1 (Not used) |
1 (Not used) |
1 |
1 |
1 (Not used) |
1 (Not used) |
If set to 1, standard loading operations are used when bulk operations are not available. |
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 compatability. |
Auto commit |
Not available |
1 If database is IQ or ODBC driver is ASA ODBC 9, ODBC uses 0 instead of the user input. |
0 |
0 |
Not available |
Not available |
Puts the connection into auto commit mode. |
Auto vacuum |
Not available |
Not available |
Not available |
Not available |
Not available |
0 |
Reclaims the space when objects are deleted from the database. |
Block inserts |
Not available |
auto Bulk operations are used only if the ODBC driver is ASA9, value is auto, there is no LOB type, and the option “Write rejected records to file” is null. |
Not available |
Not available |
Not available |
Not available |
Use block wise binding when preparing a SQL statement for execution. |
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 LOB’s 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 |
Character set to use with CTLIB (user defined). |
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 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 uses 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 bulk load |
1 (Not used) |
1/Not used |
1 |
1 |
1 (Not used) |
1 |
If set to 1, bulk operations are used, when applicable. |
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, columns names will be 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. This is used to ensure 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, else they are refered 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, will pause to write at critical moments but not as frequently as full. If you select Off = 0, data is handed off to operating system and immediately 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 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. |
Truncate reject log |
1 |
1 |
1 |
1 |
1 |
1 |
Log truncates on database connect. A value of 0 appends data to an existing log file. |
Use DELETE instead of TRUNCATE |
0 |
0 |
0 |
0 |
0 |
0 |
If set to 1, DELETE statement is used instead of TRUNCATE. |
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 error code to reject log |
1 |
1 |
1 |
1 |
1 |
1 |
Adds error code to the reject log. |
Write error text to reject log |
1 |
1 |
1 |
1 |
1 |
1 |
Adds error text to the reject log. |
Write header to reject log |
0 |
0 |
0 |
0 |
0 |
0 |
Specifies whether the reject log should contain a header line. |
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. |
Note:
|
|||||||
