DB2 UDB Only
The following parameters apply only to the DB2 UDB gateway.
blob_len
ii.hostname.gateway.db2udb.blob_len: string
Specifies the length passed to DB2 UDB when the gateway translates the OpenSQL long byte data type to the DB2 UDB BLOB data type in create table statements. For example, if blob_len is set to 1M, the following translation occurs:
create table lb_test (lb long byte);
/* is translated to */
create table lb_test (lb blob(1M));
Default: 1G
Note: Lengths for the DB2 UDB BLOB data type are specified in kilobytes (K), megabytes (M), or gigabytes (G).
clob_len
ii.hostname.gateway.db2udb.clob_len: string
Specifies the length passed to DB2 UDB when the gateway translates the OpenSQL long varchar data type to the DB2 UDB CLOB data type in create table statements. For example, if clob_len is set to 1M, the following translation occurs:
create table lb_test (lb long varchar);
/* is translated to */
create table lb_test (lb clob(1M));
Default: 1G
Note: Lengths for the DB2 UDB CLOB data type are specified in kilobytes (K), megabytes (M), or gigabytes (G).