SAP ABAP Data Element DB2WP4MXTB (Maximum joined tables)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB2 (Application Component) DB2 for z/OS
⤷
STU3 (Package) Development Class for Database Monitor
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU3 (Package) Development Class for Database Monitor
Basic Data
| Data Element | DB2WP4MXTB |
| Short Description | Maximum joined tables |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | DB2INT4U | |
| Data Type | INT4 | 4-byte integer, integer number with sign |
| Length | 10 | |
| Decimal Places | 0 | |
| Output Length | 10 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | Max joined |
| Medium | 17 | Max joined tables |
| Long | 21 | Maximum joined tables |
| Heading | 21 | Maximum joined tables |
Documentation
Definition
The maximum number of joined tables in a query block. The default is 15 and it should be used for all mySAP.com components except BW. For the BW component this parameter should be set to 100. In order to do so, edit the file DSN6SPRC which is a member in data set prefix.SDSNMACS, and locate the following line: &SPRMMXT SETC '15'. Change '15' into '100', then re-assemble and link the DSNZPxxx file by submitting the DSNTIJUZ job.
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in | 630 |
