<!-- Copyright IBM Corp. 2007 All rights reserved. Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. --> <table name="tablecat"> <sql_name>SYSCAT.TABLES</sql_name> <singular_name>Table</singular_name> <plural_name>Tables</plural_name> <description>Each row represents a <a onclick="OpenURLInFloatingWindow('http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/c0004098.htm?noframes=true');">table</a>, <a onclick="OpenURLInFloatingWindow('http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/c0004106.htm?noframes=true');">view</a> or <a onclick="OpenURLInFloatingWindow('http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/c0004097.htm?noframes=true');">alias</a> in the database. This list is generated from the <a onclick="OpenURLInFloatingWindow('http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/r0001063.htm?noframes=true');">SYSCAT.SYSTABLES</a> catalog view. </description> <rows_per_page>100</rows_per_page> <order_by_index name="tabschema" direction="A"/> <order_by_index name="tabname" direction="A"/> <display_columns> <col type="reference" name="contents"/> <col type="action" name="xmlgen"/> <col type="column" name="tabschema"/> <col type="column" name="tabname"/> <col type="column" name="type"/> <col type="column" name="status"/> <col type="action" name="rowcount"/> <col type="column" name="card"/> <col type="reference" name="cols"/> <col type="reference" name="indexes"/> |
<col type="reference" name="Dependencies"/> |
<col type="reference" name="auth"/> |
<col type="reference" name="tbspace"/> <col type="column" name="tbspace"/> </display_columns> <action name="rowcount"> <c_title>Count</c_title> <icon>images/icon-count.gif</icon> <actionScript name="helloworld" type="serverAction"> <parameterList> <parameter name="action" type="fixed"> <value>rowCount</value> </parameter> <parameter name="schema" type="blockValue"> <value>tabschema</value> </parameter> <parameter name="name" type="blockValue"> <value>tabname</value> </parameter> </parameterList> <followOnAction condition=""> <task> <action name="ok" type="alert"> <message>Total number of rows: ?RETURN?</message> <parameterList> <parameter name="RETURN" type="returnObject"> <value>helloworld.returnValue</value> </parameter> </parameterList> </action> </task> </followOnAction> </actionScript> </action> <reference name="contents"> <c_title>Contents</c_title> <reftype>table</reftype> <refvalue></refvalue> <icon>images/icon-link-calendar.gif</icon> <ref foreign_column_name="schema"> <local_column_name>tabschema</local_column_name> </ref> <ref foreign_column_name="table"> <local_column_name>tabname</local_column_name> </ref> </reference> <action name="xmlgen"> <c_title>XML</c_title> <icon>images/icon-xml.gif</icon> <actionScript name="helloworld" type="block"> <followOnAction condition=""> <task> <assignLocalParameter name="TABLENAME" type="blockValue"> <value>tabname</value> </assignLocalParameter> <assignLocalParameter name="SCHEMANAME" type="blockValue"> <value>tabschema</value> </assignLocalParameter> <loadPage> <pageWindow target="_blank"> <panel name="main"> <URL> <![CDATA[ http://?DB2MC_SERVER?/?ACTION_PROCESSOR??action=xmlgen&schemanameparm=?SCHEMANAME?&tablenameparm=?TABLENAME?&USE_CONNECTION=?ACTIVE_DATABASE_CONNECTION? ]]> </URL> </panel> </pageWindow> </loadPage> </task> </followOnAction> </actionScript> </action> <reference name="cols"> <c_title>Columns</c_title> <reftype>table</reftype> <refvalue>colcatdetail</refvalue> <icon>images/icon-column.gif</icon> <ref foreign_column_name="tabschema"> <local_column_name>tabschema</local_column_name> </ref> <ref foreign_column_name="tabname"> <local_column_name>tabname</local_column_name> </ref> </reference> <reference name="auth"> <c_title>Privileges</c_title> <reftype>table</reftype> <refvalue>Authority/tabauth</refvalue> <icon>images/icon-privilege.gif</icon> <ref foreign_column_name="tabschema"> <local_column_name>tabschema</local_column_name> </ref> <ref foreign_column_name="tabname"> <local_column_name>tabname</local_column_name> </ref> </reference> |
<reference name="Dependencies"> <c_title>Dependencies</c_title> <reftype>table</reftype> <refvalue>SYSCAT.TABDEP</refvalue> <icon>images/icon-workload.gif</icon> <ref foreign_column_name="bschema"> <local_column_name>tabschema</local_column_name> </ref> <ref foreign_column_name="bname"> <local_column_name>tabname</local_column_name> </ref> </reference> |
<reference name="indexes"> <c_title>Indexes</c_title> <reftype>table</reftype> <refvalue>indexcat</refvalue> <icon>images/icon-index.gif</icon> <ref foreign_column_name="tabschema"> <local_column_name>tabschema</local_column_name> </ref> <ref foreign_column_name="tabname"> <local_column_name>tabname</local_column_name> </ref> </reference> |
<reference name="tbspace"> <c_title></c_title> <reftype>table</reftype> <refvalue>Performance/tbsputil</refvalue> <icon>images/icon-tbs.gif</icon> <ref foreign_column_name="tbsp_id"> <local_column_name>tbspaceid</local_column_name> </ref> </reference> <column name="tabschema"> <c_sql_name>TABSCHEMA</c_sql_name> <c_title>Schema</c_title> <c_pkey>p</c_pkey> <c_prefill> <table>schema</table> <column>SCHEMANAME</column> </c_prefill> </column> <column name="tabname"> <c_sql_name>TABNAME</c_sql_name> <c_title>Table Name</c_title> <c_pkey>p</c_pkey> </column> <column name="card"> <c_sql_name>CARD</c_sql_name> <c_title>Number of Rows</c_title> <c_presentation>n</c_presentation> <c_drill>n</c_drill> <c_prefill>n</c_prefill> <c_column_mask> <value_mask value="-1"><mask>No Stats</mask></value_mask> </c_column_mask> </column> <column name="type"> <c_sql_name>TYPE</c_sql_name> <c_title>Type</c_title> <c_prefill>y</c_prefill> <c_column_mask_file>masks/tableTypeMasks.xml</c_column_mask_file> </column> <column name="status"> <c_sql_name>STATUS</c_sql_name> <c_title>Status</c_title> <c_prefill>y</c_prefill> <c_column_mask> <value_mask value="C"><mask>Set integrity pending</mask></value_mask> <value_mask value="N"><mask>Normal</mask></value_mask> <value_mask value="X"><mask>Inoperative</mask></value_mask> </c_column_mask> </column> <column name="tbspaceid"> <c_sql_name>TBSPACEID</c_sql_name> <c_title>Tablespace ID</c_title> <c_presentation>n</c_presentation> <c_drill>n</c_drill> <c_prefill>y</c_prefill> </column> <column name="tbspace"> <c_sql_name>TBSPACE</c_sql_name> <c_title>Tablespace</c_title> <c_prefill>y</c_prefill> </column> </table> |