The following table gives the contents of the clispb.dat file. The defaults are recommended for typical workstation-attached systems. See the corresponding field name for more information.
Name | Default | DBCAREA Field Name |
---|---|---|
change_opts | Y | Change Options |
charset_id* | ASCII | Character Set Pointer This field contains either the character set code or the character set name. In the DBCAREA charset_id is named Character Set Pointer.
|
connect_type | N | Connect Type |
charset_type | N | Character Set Type |
columnInfo | 0 | Varying-length column title and format information |
consider_aph_resps | N | APH/1 MB Responses |
data_encryption | N | Data Encryption |
date_form | D | Date Form |
dbriseg | N | Segmented data transfer for (TDSP) |
dynamic_result_sets_allowed | N | Dynamic Result Sets Allowed |
i_dbcpath | dbc | Input DBCpath |
keep_resp | N | Keep Response |
lang_conformance | N | Language Conformance |
lang_id | EN | Language to be used for generating CLI messages |
loc_mode | N | Locate Mode |
log_mech | N/A | Logon Mechanism Name |
max_decimal_returned | 0 | Maximum Decimal Precision |
max_num_sess for a single process | 300 | Maximum Number of Sessions |
maximum_parcel | O | Maximum Parcel |
msg_security | N | Message Security |
parcel_mode | Y | Parcel Mode Fetch |
req_buf_len | 1024 | Request Buffer Length |
req_proc_opt | E | Request Processing Option |
request_mode | P | Request Mode |
resp_ buf_len | 8192 | Response Buffer Length |
resp_mode | R | Response Mode |
ret_time | N | Return Time |
return_object | D | Type of LOB to be returned |
send_delegated_credentials | Y | send delegated credentials |
save_resp_buf | N | Save Response Buffer (not used) |
SP_return_result | 0 | Stored Procedure return result |
tell_about_delay | Y | Tell About Delay |
timing_precision | 20 | Timing-Precision |
two_resp_bufs | N | Two Response Buffer |
tx_semanticss | D | Transaction Semantics |
use_presence_bits | N | Use Presence Bits |
var_len_fetch | N | Variable Length Fetch |
var_len_req | N | Variable Length Request |
wait_across_delay | N | Wait Across Delay |
wait_for_resp | N | Wait For Response |
If you have write access to clispb.dat, you may edit clispb.dat and replace the current names with the old (alternate) ones. The following table gives the corresponding names:
Current | Old |
---|---|
change_opts | seto |
data_encryption | secure |
i_dbcpath | dbcname |
keep_resp | krsp |
loc_mode | floc |
max_num_sess | maxsess |
parcel mode | btpm |
req_buf_len | reqlen |
req_proc_opt | funt |
resp_buf_len | rsplen |
resp_mode | rmod |
ret_time | rts |
save_resp_buf | fsvb |
tell_about_delay | crtl |
two_resp_bufs | twob |
use_presence_bits | idta |
var_len_fetch | fvar |
var_len_req | rvar |
wait_across_delay | crsw |
wait_for_resp | bsyw |
long_conformance | conf |
CLI does not recognize the old symbol names.