Reformatted File: Example - Call-Level Interface Version 2

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 Responsest

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

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

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

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 Database
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