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 | C:char set code N:name R:run logon |
columnInfo=O | C | E/O | varying length column allowed |
connect_type=c | char | C/R | C:connect logon (used on host) |
connect_wait=10 | char | 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 | Y:keepresp, N:resp, P:positioning information |
lang_conformance=N | char | N/2/3 |
|
loc_mode=N, | C | Y/N | fetch use locate mode |
max_decimal_returned=0 | Int | 0-255 | maximum decimal precision value |
max_num_sess=300 | Int | 1-999 | max. 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 | perform/execute SQL request/perform&execute /analyze parameterized SQL |
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 | R:record mode, F:field mode, I:indicator mode M:MultiPart Indicator mode |
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 |
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.