SAP ABAP Table SQTEXT_DB4 (iSeries: SQL Statement Text (Database Monitor))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
     ⤷ STU4 (Package) CCMS / AS/400

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SQTEXT_DB4	Table Relationship Diagram
Short Description	iSeries: SQL Statement Text (Database Monitor)

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	SYSID	☑	SYSYSID	SYCHAR08	CHAR	8	0	Name of SAP System	SQ1000_DB4
2	IPLTIME	☑	CHAR14	CHAR14	CHAR	14	0	Text field length 14
3	QQKEY	☑	QQKEY	QQKEY	CHAR	17	0	iSeries: Key Field (Database Monitor)
4	QQTIME	☐	QQTIME	QQTIME	CHAR	26	0	iSeries: Record Creation Timestamp (Database Monitor)
5	QQC11	☐	QQC11	QQC11	CHAR	1	0	iSeries: Reserved Field (Database Monitor)
6	QQC12	☐	QQC12	QQC12	CHAR	1	0	iSeries: Reserved Field (Database Monitor)
7	QQC21	☐	QQC21	QQC21	CHAR	2	0	iSeries: Reserved Field (Database Monitor)
8	QQC22	☐	QQC22	QQC22	CHAR	2	0	iSeries: Reserved Field (Database Monitor)
9	QQI1	☐	QQI1	QQI1	INT4	10	0	iSeries: Reserved Field (Database Monitor)
10	QQI2	☐	QQI2	QQI2	INT4	10	0	iSeries: Reserved Field (Database Monitor)
11	QQC301	☐	QQC301	QQC301	CHAR	30	0	iSeries: Reserved Field (Database Monitor)
12	QQC302	☐	QQC302		CHAR	30	0	iSeries: Reserved Field (Database Monitor)
13	QQSTTX_LNG	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
14	QQSTTX	☐	QQSTTX	QQLCHR	LCHR	8000	0	iSeries: Statement Text (Database Monitor)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SQTEXT_DB4	SYSID	SQ1000_DB4	SYSID

History

Last changed by/on	SAP	20130604
SAP Release Created in