Large-row is used to indicate the application wishes to support the 1M Response and Request Rows. Note, for this option to be effective, the Database must support 1M Rows. This feature is in the Database from 16.00 and later.
Large-row-support exists only when DBCHINI had been called for a DBCAREA with Totallength set to at least 1024 (that is, the returned DBCAREA Level value is at least 2). For a smaller DBCAREA, Large-row-support is ignored.
In this language... | The variable name for Large-row-support is... |
---|---|
COBOL | LARGE-ROW |
PL/I | LARGE_ROW |
C, C++ | largeRow (case is significant) |
IBM Assembler | DBRILR |
This routine... | Does this for Large-row-support. . . |
---|---|
DBCHINI | writes |
DBCHCL | reads (CON; IRQ; IWPF) |
Large-row-support is used by... | To... |
---|---|
applications | ReadWrite |
If Large-row-support is 'N' or not specified, the Teradata DBS will continue to return Permanent and Response Rows at a maximum of 64K. If this value is 'Y' and the Teradata DBS is on a Large Cylinder System, the Teradata DBS will return Permanent and Response Rows at a maximum of 1M. Actual row lengths may be less due to overhead.
On Small Cylinder systems, the maximum size of Perm rows and Response rows will remain approximately 64KB regardless of this setting.
TDP also has to be at least at 16.00.
If the Teradata Database is to use Large Row... | Then change the value for Large Row Support to. . . |
---|---|
Indicates application wishes to use Large Row if supported by system | 'Y'
|
Does not wish to use Large Rows even if system supports Large Rows | 'N'
|