Hierarchy
⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
⤷ STU4 (Package) CCMS / AS/400
Basic Data
Data Element | QTFN |
Short Description | iSeries: System Name of Table (Database Monitor) |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | AS4TAB | |
Data Type | CHAR | Character String |
Length | 30 | |
Decimal Places | 0 | |
Output Length | 30 | |
Value Table | DD02L |
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 | 11 | Table |
Medium | 21 | Table (System Name) |
Long | 41 | Table (System Name) |
Heading | 55 | Table (System Name) |
Documentation
Definition
QQTFN is the SQL name of the file (SQL table or view) specified in a statement.
If the file specified in a statement is a view, QPTFN is the physical file (table) accessed.
Note
On an iSeries each SQL table, view or index is an OS/400 object as well. OS/400 object names can be up to ten characters long. If an SQL table, view or index is created with a name longer than 10 characters, the operating system maps this SQL name to a unique operating system name of exactly ten characters (first five characters of the SQL name followed by a five-digit number).
Example
An SQL table with the name MATERIAL_INFO is created in library LIB.
OS/400 checks whether an object with the name MATER00001 already exists in this library LIB. If no object of the name MATER00001 exists, it is the OS/400 name of the SQL table created. If the name is already used for another object in this library, then the names MATER00002, MATER00003, and so on are checked until an unused name is found.
History
Last changed by/on | SAP | 20070813 |
SAP Release Created in |