STG_IS_REP_SQL_STATS

Enables access to the SQL for a report execution. This table is used when the Report Job SQL option is selected in the Statistics category of the Project Configuration Editor. The data load process moves this table's information to the IS_REP_SQL_STATS table, which has the same columns and datatypes.

Column	Description	SQL Server Data-type	Oracle Data-type	DB2 Data-type	Teradata Data-type	Sybase Data-type	MySQL Data-type
DAY_ID	Day the SQL pass was started.	DATE	TIMESTAMP	DATE	DATE	DATE	DATE
HOUR_ID	Hour the SQL pass was started.	TINYINT	NUMBER(3)	SMALLINT	BYTEINT	TINYINT	TINYINT
MINUTE_ID	Minute the SQL pass was started.	SMALLINT	NUMBER(5)	SMALLINT	SMALLINT	SMALLINT	SMALLINT
JOBID	Job ID.	INTEGER	NUMBER(10)	INTEGER	INTEGER	INTEGER	INTEGER
SQLPASSSEQUENCE	Sequence number of the SQL pass.	SMALLINT	NUMBER(5)	SMALLINT	SMALLINT	SMALLINT	SMALLINT
SESSIONID	GUID of the user session.	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)
SERVERID	GUID of the server definition.	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)
STARTTIME	Start timestamp of the SQL pass.	DATETIME	TIMESTAMP	TIMESTAMP	TIMESTAMP	DATETIME	DATETIME
FINISHTIME	Finish timestamp of the SQL pass.	DATETIME	TIMESTAMP	TIMESTAMP	TIMESTAMP	DATETIME	DATETIME
EXECTIME	Execution time, in milliseconds, for the SQL pass.	INTEGER	NUMBER(10)	INTEGER	INTEGER	INTEGER	INTEGER
SQLSTATEMENT	SQL used in the pass.	VARCHAR(4000)	VARCHAR2(4000)	VARCHAR(4000)	VARCHAR(4000)	VARCHAR(4000)	VARCHAR(4000)
SQLPASSTYPE	Type of SQL pass: 0: SQL unknown 1: SQL select 2: SQL insert 3: SQL create 4: Analytical 5: Select into 6: Insert into values 7: Homogen. partition query 8: Heterogen. portend query 9: Metadata portend pre-query 10: Metadata portend list pre-query 11: Empty 12: Create index 13: Metric qual. break by 14: Metric qual. threshold 15: Metric qual. 16: User-defined 17: Homogen. portend loop 18: Homogen. portend one tbl 19: Heterogen. portend loop 20: Heterogen. portend one tbl 21: Insert fixed values into 22: Datamart from Analytical Engine 23: Clean up temp resources 24: Return elm number 25: Incremental elem browsing 26: MDX query 27: SAP BI 28: Intelligent Cube instruc 29: Heterogen. data access 30: Excel file data import 31: Text file data import 32: Database table import 33: SQL data import	TINYINT	NUMBER(3)	SMALLINT	BYTEINT	TINYINT	TINYINT
TOTALTABLEACCESSED	Number of tables hit by the SQL pass.	SMALLINT	NUMBER(5)	SMALLINT	SMALLINT	SMALLINT	SMALLINT
DBERRORMESSAGE	Error message returned from database.	VARCHAR(4000)	VARCHAR2(4000)	VARCHAR(4000)	VARCHAR(4000)	VARCHAR(4000)	VARCHAR(4000)
RECORDTIME	Timestamp of when the record was written to the database, according to database system time.	DATETIME	TIMESTAMP	TIMESTAMP	TIMESTAMP	DATETIME	DATETIME
SERVERMACHINE	(Server machine name:port number) pair.	VARCHAR(255)	VARCHAR2(255)	VARCHAR(255)	VARCHAR(255)	VARCHAR(255)	VARCHAR(255)
PROJECTID	GUID of the project.	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)
DBINSTANCEID	GUID of the physical database instance.	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)
DBCONNECTIONID	GUID of the database connection.	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)
DBLOGINID	GUID of the database login.	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)
SQLSTATEMENTSEQ	Sequence number of the SQL statement.	TINYINT	NUMBER(3)	SMALLINT	BYTEINT	TINYINT	TINYINT
REPOSITORYID	GUID of the metadata repository.	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)