The clispb.dat Listing|System Parameter Block (SPB) File | CLIv2 - The clispb.dat Listing - Call-Level Interface Version 2

Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-06-12
dita:mapPath
zws1641280432166.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2418
Product Category
Teradata Tools and Utilities

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
logmech_name N/A Logon Mechanism Name
logon_timeout 240 Logon Timeout
max_decimal_returned 0 Maximum Decimal Precision
max_num_sess 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
sslca   CA certificate file path. No matching DBCAREA field name.
sslcapath   The directory containing CA certificates. No matching DBCAREA field name.
sslcrc allow Desired certificate revocation check level. No matching DBCAREA field name.
sslmode allow Desired TLS security level
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