EnableET IBM data server driver configuration keyword
The EnableET keyword enables the cli application to use an external table interface underneath for cliload in an instance-based client. The EnableET keyword can be defined in any section (<database>) of the db2dsdriver.cfg file.
Attention: This feature is available in version 11.5.4 and later versions.
- db2cli.ini keyword syntax:
- Not available.
- Equivalent IBM® Data Server Provider for .NET connection string keyword
- Not available.
- IBM data server driver configuration file (db2dsdriver.cfg) syntax
- <parameter name="EnableET" value="1"/>
- Default setting:
- 0
- Usage notes:
- Enable Et can take two possible values:
- "1": Use the external table interface underneath for cliload in an instance-based client.
- "0": Cliload will use the load interface underneath in instance-based clients.
- Restriction
- INSERT statement in cliload using ET must contain all columns of the table. Otherwise, the
following error will be thrown:
SQL0117N The number of values assigned is not the same as the number of specified or implied columns or variables. SQLSTATE=42802