List of available tables
The list of available tables is a list of the schemas and tables that are available to be used in the current SQL statement or File Upload statement.
Importance of the list of available tables: |
---|
All the levels of filtering for schema names and table names in Z and I Emulator for Web affect one single area of the user interface: the list of available tables. |
The levels of filtering determine which schema names and table names appear in the list of available tables (see Levels of filtering for schema names and table names). |
The list of available tables is located:
- On the Tables tab of the SQL Wizard.
- Java 1 browsers: see Select Table(s).
- Java 2-enabled browsers: see Available tables.
- On the Table tab of the File Upload Wizard.
- Java 1 browsers: see Select a reference table, Select a table.
- Java 2-enabled browsers: see Available tables.
In Java 1 browsers, the list of available tables appears as a listbox of table names:
- Each table name is in the format
schema_name.
table_name (for example,
HODTEST.TEST01
), - A checkbox precedes each table name.
In Java 2-enabled browsers, the list of available tables appears as a tree of schemas and tables.
Related topics:
- Levels of filtering for schema names and table names
- Specifying a list of available schemas and tables
- Table Filter (Administrator, Database On-Demand)
- Table filter
- Java 1 browser:
- Table Filter (SQL Wizard)
- Table Filter (File Upload)
- Selected schema(s) (SQL Wizard, File Upload)
- Enter the table name filter to use below (SQL Wizard, File Upload)
- Java 2-enabled browser:
- Table Filter (SQL Wizard)
- Table Filter (File Upload)
- Selected schemas (SQL Wizard, File Upload)
- Enter a table name filter (SQL Wizard, File Upload)