Max-decimal-returned - Teradata Tools and Utilities

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

Product
Teradata Tools and Utilities
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
lvt1544831946862.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

Max-decimal-returned specifies the maximum precision of DECIMAL values in a response. The option is ignored for Field Response-mode. Max-decimal-returned exists only when DBCHINI had been called for a DBCAREA with Total-length set to at least 640 (that is, the returned DBCAREA Level value is at least 1). For a smaller DBCAREA, Max-decimal-returned is ignored.

In this language... The variable name for Max-decimal-returned is...
COBOL MAX-DECIMAL-RETURNED
PL/I MAX_DECIMAL_RETURNED
C, C++ maxDecimalReturned
IBM Assembler DBRIMDR
Routine. Action for Max-decimal-returned
DBCHINI writes
DBCHCL reads (RSUP; IRQ; IWPF)
Max-decimal-returned is used by... To...
applications write.

The database rejects any value greater than the decimal precision value obtained using the DBCHQE SQL-limits query. If Max-decimal-returned is omitted or specified as zero, the client default of 18 is assumed, unless the HSHSPB MDR specification is used to specify a different default.