17.10 - Reformatted File: Example - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

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 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
  • T – Teradata Format
  • A – ANSI format
  • D – Default
dbriseg=N char N/F/I/L/C
  • N – Default
  • F – First segment
  • I – Last segment
  • L – Last segment
  • C – Cancel Request
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
  • N – None
  • 2 – FIPS127-2
  • 3 – FIPS127-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
  • O – 32k
  • H – 64k
msg_security=N char Y/N
  • Y: To encrypt the message
  • N: Not to encrypt the message
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:
  • P: parcelmode
  • B: buffermode
  • D: descriptor list
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
  • D: Data
  • T: Tx-related locators
  • S: Spool-related locator
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
  • 0 : TCP auto-tuning
  • others: TCP send/receive buffer size
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
  • D: server default
  • T: Teradata
  • A: ANSI
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.

The value of 1048500 is only when support for APH and extended response exists at the server to which the session is logged on.