SAP Function ST04_DB4_GET_SQR_INFO - AS/400: Get SQL Requests/Top50 info for ST04 Detail Analysis

Parameter	Reference	Type	Length	Default	Optional	Text
CURRENT_SYSTEM	DB6NAVSYST	u	992		X	DB6: Globale Steuerdaten für Navigationsrahmen
LIMIT_ROWS	QQC11	C	1	'X'	X	Only the 50 slowest statement are to be selected
MAX_ROWS	I	I	4	300	X
RESETFLAG	DB4QQPAR-QRESET	C	1	SPACE	X	Feld vom Typ CHAR z.Zt nicht verwendet
SELECTION_SET	DB4SQR0100	u	8270		X	Specification which statements to select
TAB_NAME	DD02L-TABNAME	C	30	SPACE	X	Table name

Parameter	Reference	Length	Optional	Text
SQR0100	DB4SQR0100	8270	X	Overview info of statements selected

Exception	Text
NO_DATA_FOUND	No data found
NO_OUTPUT_TABLE_SPECIFIED	No table specified to receive info specified

Functionality
The function module collects data from the mySAP ERP databaseperformance tables about either the 50 slowest or all statementscorresponding to the selection citeria specified in the input parameterSELECTION_SET. The data is displayed in transaction ST04, DetailAnalysis Menu, TOP50 or SQL Requests (the report executes isRSDB4SQR.

Use
The table parameter SQR0100 is used for exporting information only. Datain it handed to the function module will be removed.
If this table parameter is not specified by the caller the functionmocule will return the exception NO_OUTPUT_TABLE_SPECIFIED.
If the input parameter TOP50 equals 'Y' the selection criteria specifiedin the input parameter SELECTION_SET is ignored and info about the 50slowest statements is selected into the output table SQR0100.
If the input parameter TOP50 is not equal to 'Y' info about allstatements corresponding to the input parameter SELECTION_SET isselected.

Example
Examples on how to call the function module is to found inRSDB4SQR.