The following lines are an example of a reformatted file that contains valid syntax:
req_buf_len=1024, resp_buf_len=8192, resp_mode=F, max_num_sess=300 wait_for_resp=N, ret_time=Y, i_dbcname=mysite, loc_mode=Y
The application program may specify values in the DBCAREA for the various option arguments before calling DBCHCL. The program indicates to CLI that changes to the options are to be honored by setting the value of Change Options to Y in the DBCAREA. Depending on the function code set in the DBCAREA, different options are looked at by DBCHCL.
The following table lists the fields by their mnemonic names and specifies the default value and the set of possible values.
Opt=Dflt | Type | Values | Description |
---|---|---|---|
change_opts=Y | C | Y/N | Options-changed flag |
charset_type=N | char | C/N/R |
|
columnInfo=O | C | E/O | Varying length column allowed |
connect_type=c | char | C/R | C:connect logon (used on host) |
connect_wait=10 | Int | 0-255 | Connect wait |
consider_aph_resps=N | char | Y/N | APH/1 MB Responses |
data_encryption=N, | C | Y/N | Data encryption |
date_form=D | char | T/A/D |
|
dbriseg=N | char | N/F/I/L/C |
|
dynamic_result_sets_allowed=N | C | Y/N | Dynamic result sets allowed |
i_dbcpath=dbc | C | 1-8ch | Name of default database computer |
keep_resp=N, | C | Y/N/P |
|
lang_conformance=N | char | N/2/3 |
|
loc_mode=N, | C | Y/N | Fetch use locate mode |
logon_timeout=240 | Int | number | Logon timeout (seconds) |
max_decimal_returned=0 | Int | 0-255 | Maximum decimal precision value |
max_num_sess=300 | Int | 1-999 | Maximum concurrent sessions |
maximum_parcel=O | char | O/H |
|
msg_security=N | char | Y/N |
|
parcel mode=Y, | C | Y/N | Parcel mode (buffer mode if no) |
req_buf_len=1024, | Int | 1K-64K | Request buffer size |
req_proc_opt=E | C | E/P/B/S |
|
requst_mode=P | char | P/B/D | Options for request handling:
|
resp_buf_len=8192, | Int | 1K-64K | Response buffer size |
resp_mode=R, | C | R/F/I/M |
|
ret_time=N, | C | N/Y | Return time stamps |
return_object=D | char | D/T/S |
|
save_resp_buf=N, | C | Y/N | Save buff for re-use at erq |
send_delegated_credentials=Y | char | Y/N | Send delegated credentials |
SP_return_result=0 | Int | 0-5 | Stored Procedure return result |
tcp_buf_size=0 | int | number |
|
tell_about_delay=N, | C | Y/N | Inform application of crash |
two_resp_bufs=N, | C | Y/N | ‘double buffering’ |
tx_semantics | char | D/T/A |
|
use_presence_bits=N, | C | Y/N | Y:indicdata mode |
var_len_fetch=N, | C | Y/N | Return fetch data var string |
var_len_req=N, | C | Y/N | Request data is var string |
wait_across_delay=N, | C | Y/N | Wait for resp if dbc crash |
wait_for_resp=N, | C | Y/N | Allow CLI to block on reads |
To be specific, the range on the response buffer size and request buffer size is 1024 bytes to 32768 bytes, if Maximum Parcel is set to O or 65536/1048500, if Maximum Parcel is set to H, of which 16 bytes are reserved for internal use. The maximum number of concurrent sessions for a single process may be less than 999, depending on your system and the local system configuration.