Viewing Column Details

The View Column dialog box allows you to see detailed column information for tables as you enter a SQL statement in the Enter Query task of the Checklist for the Execute Query activity. This task describes how to access the View Column Details dialog box.

Procedure

  1. Create or open an Execute Query activity.
  2. Select the Enter Query task from the Checklist. The Enter Query pane is displayed.
  3. Click View Columns. The View Columns dialog box is displayed.
  4. To change the data viewed in the View Columns dialog box, select from the following options:
    • To see detailed column information, select a table in the list. Column names, datatypes, sizes, and nullable properties display in the right pane.
    • To see tables in a different schema, select a schema from the Filter by User Schema list.
    • To see tables for all schemas, click Clear.
    • To filter out any buffer or control tables created by the Web Management Console (WMC) that are used internally by the Integration Appliance, select the Hide Buffer and Control Tables option.
      Note: This filter only hides buffer and control tables that use the standard names generated in scripts from Studio.



Feedback | Notices


Timestamp icon Last updated: Tuesday, 27 September 2016


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.doc/conn_db_Viewing_Column_Details.html