<table name="UnknowntestTabDef">
<sql_name>UnknowntestTabDef</sql_name>
<singular_name>UnknowntestTabDef</singular_name>
<plural_name>UnknowntestTabDef</plural_name>
<inlinequery>
<![CDATA[
SELECT APPLICATION_HANDLE,
APPLICATION_NAME,
TOTAL_CPU_TIME,
TOTAL_ACT_TIME,
ACT_COMPLETED_TOTAL,
TOTAL_WAIT_TIME,
CLIENT_IDLE_WAIT_TIME
FROM TABLE(MON_GET_CONNECTION(NULL, -1)) as t
]]>
</inlinequery>
<description>Query from ad hoc</description>
<rows_per_page>50</rows_per_page>
<order_by_index></order_by_index>
<display_columns>
<col type="column" name="APPLICATION_HANDLE"/>
<col type="column" name="APPLICATION_NAME"/>
<col type="column" name="TOTAL_CPU_TIME"/>
<col type="column" name="TOTAL_ACT_TIME"/>
<col type="column" name="ACT_COMPLETED_TOTAL"/>
<col type="column" name="TOTAL_WAIT_TIME"/>
<col type="column" name="CLIENT_IDLE_WAIT_TIME"/>
</display_columns>
<column name="APPLICATION_HANDLE">
<c_sql_name>APPLICATION_HANDLE</c_sql_name>
<c_title>APPLICATION_HANDLE</c_title>
<c_presentation></c_presentation>
<c_drill>n</c_drill>
<c_pkey>y</c_pkey>
</column>
<column name="APPLICATION_NAME">
<c_sql_name>APPLICATION_NAME</c_sql_name>
<c_title>APPLICATION_NAME</c_title>
<c_presentation></c_presentation>
<c_drill>y</c_drill>
</column>
<column name="TOTAL_CPU_TIME">
<c_sql_name>TOTAL_CPU_TIME</c_sql_name>
<c_title>TOTAL_CPU_TIME</c_title>
<c_presentation></c_presentation>
<c_drill>n</c_drill>
</column>
<column name="TOTAL_ACT_TIME">
<c_sql_name>TOTAL_ACT_TIME</c_sql_name>
<c_title>TOTAL_ACT_TIME</c_title>
<c_presentation></c_presentation>
<c_drill>n</c_drill>
</column>
<column name="ACT_COMPLETED_TOTAL">
<c_sql_name>ACT_COMPLETED_TOTAL</c_sql_name>
<c_title>ACT_COMPLETED_TOTAL</c_title>
<c_presentation></c_presentation>
<c_drill>n</c_drill>
</column>
<column name="TOTAL_WAIT_TIME">
<c_sql_name>TOTAL_WAIT_TIME</c_sql_name>
<c_title>TOTAL_WAIT_TIME</c_title>
<c_presentation></c_presentation>
<c_drill>n</c_drill>
</column>
<column name="CLIENT_IDLE_WAIT_TIME">
<c_sql_name>CLIENT_IDLE_WAIT_TIME</c_sql_name>
<c_title>CLIENT_IDLE_WAIT_TIME</c_title>
<c_presentation></c_presentation>
<c_drill>n</c_drill>
</column>
</table>
|