Corporation Video Gaming Accessories User Manual

Modeling Interactions for OracleAS Adapter for IMS/DB
2-34 Oracle Application Server Adapters for IMS/DB User's Guide
Test import tables Select this table to create an SQL statement to test the import
table. You can base the statement on the Full table or Selected
columns. When you select this option, the following screen
opens with an SQL statement based on the table or column
entered at the bottom of the screen.
Enter the following in this screen:
■ Data file name: Enter the name of the file that contains the
data you want to query.
■ Limit query results: Select this if you want to limit the
results to a specified number of rows. Enter the amount of
rows you want returned in the following field. 100 is the
default value.
■ Define Where Clause: Click Add to select a column to use
in a Where clause. In the table below, you can add the
operator, value and other information. Click on the columns
to make the selections. To remove a Where Clause, select the
row with the Where Clause you want t remove and then
click Remove.
The resulting SQL statement with any Where Clauses that you
added are displayed at the bottom of the screen.
Click OK to send the query and test the table.
Attribute menu
Change data type Select Change data type from the Attribute menu to activate the
Type column, or click on the Type column and select a new data
type from the drop-down list.
Table 2–14 (Cont.) Field Manipulation Screen Commands
Command Description