The interface-specific database options table provides database options available for each of the interfaces in an ETL project.
A hyphen (-) indicates that the database option has no default value. You can enter an appropriate value.
“NA” indicates that the database option is not provided or available 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 |
NA |
0 |
NA |
NA |
NA |
NA |
When building the ODBC connection string, always add the credentials to the connection string. |
API trace |
NA |
NA |
False |
False |
NA |
NA |
Enable CTLIB trace facility. |
API version |
NA |
NA |
150 |
125 |
NA |
NA |
CTLIB API version compatibility. |
Auto vacuum |
NA | NA |
NA | NA |
NA |
0 |
Reclaims the space when objects are deleted from the database. |
BLOB chunk size |
1024 While fetching LOB data from the file, Sybase IQ InfoPrimer fetches 1024 bytes from the file and writes them to the database each time. |
NA |
NA |
NA |
NA |
NA |
Determines the size at which LOBs are truncated. |
BLOB fetch mode |
LOB_ INLINE |
INLINE |
NA |
NA |
NA |
NA |
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 |
NA |
NA |
NA |
NA |
NA |
10 |
Creates a handler, which waits for the specified number of seconds on encountering a locked database table. |
Cache size |
NA |
NA |
NA |
NA |
NA |
3000 |
Number of pages to use in cache. |
CLIENT_ CHARSET |
NA |
NA |
- |
- |
NA |
NA |
User defined character set to use with Client Library (CTLIB). |
CLIENT_ CONVERSION |
NA |
NA |
0 (ASE) 1 (ASA/IQ) |
0 (ASE) 1 (ASA/IQ) |
NA |
NA |
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 |
NA |
NA |
- |
- |
NA |
NA |
The character set to be used when CLIENT_ CONVERSION = 1. |
Database name |
NA |
NA |
- |
- |
NA |
NA |
Database name. |
DBMS_VER |
NA |
NA |
- |
- |
NA |
NA |
Database version. |
Default cache size |
NA |
NA |
NA |
NA |
NA |
3000 |
Default number of pages to use in cache. |
Disconnect timeout |
NA |
10 On Windows 32-bit, Sybase IQ InfoPrimer always uses the default value.On other platforms, this option is not used. |
NA |
NA |
NA |
NA |
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 |
NA |
NA |
NA |
NA |
1 |
NA |
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 |
NA |
0 |
Component stops execution after a time interval in seconds. (0 <= means no timeout). |
Extended connect options |
NA |
- |
NA |
NA |
- |
NA |
Allows additional driver-specific parameters to be added to an ODBC connection string. |
Full column names |
NA |
NA |
NA |
NA |
NA |
1 |
When set to 1, column names are fully qualified, following this pattern: <table-name/alias> <column-name>. |
Internal database |
NA |
NA |
NA |
NA |
NA |
- |
Database reference. |
Isolation level |
DEFAULT (Not used) |
DEFAULT |
DEFAULT (Not used) |
DEFAULT (Not used) |
NA |
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) |
NA |
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 |
NA |
0 This value is 0 rather than the user input, when DBMS is IQ or ODBC driver is ASA9. |
NA |
NA |
NA |
NA |
Whether or not to enable ODBC numeric support. |
Object name end quote |
" |
- ODBC uses the value queried from DBMS rather than the user input. |
] |
] |
- |
NA |
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. |
[ |
[ |
- |
NA |
Beginning character to be used as quote when building SQL statements. |
PAD_BLANKS |
NA |
NA |
0 |
0 |
NA |
NA |
Maintains a constant column width using space characters. |
Page size |
NA |
NA |
NA |
NA |
NA |
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 |
" |
NA |
NA |
NA |
NA |
NA |
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 |
NA |
NA |
NA |
NA |
NA |
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 |
NA |
NA |
0 (Not used) |
0 (Not used) |
NA |
NA |
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 |
NA |
NA |
NA |
NA |
NA |
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 |
NA |
NA |
NA |
NA |
NA |
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 |
NA |
1 If database is IQ, or driver name contains “SYSYBNT” or “LIBDB2.A,”ODBC uses 1 instead of the user input. |
NA |
NA |
NA |
NA |
Force conversion of numeric data to string. |
Use system views |
True |
NA |
NA |
NA |
NA |
NA |
Use DBA system tables to show metadata instead of per-user metadata. |
Validate result column binding |
NA |
NA |
NA |
NA |
1 |
NA |
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) |
NA |
NA |
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. |