Designing: Select Tables/Views/Aliases

Classic Java CAPS

Developing Java CAPS Projects

Using SOAP Message Handlers

Creating a Runtime Environment

Designing Business Processes in the Sun Business Process Manager

Working with TCP/IP HL7 Collaborations

Developing Sun Master Indexes (Repository)

Developing Sun Master Patient Indexes

Developing OTDs for Application Adapters

Developing OTDs for Communication Adapters

Developing OTDs for Database Adapters

Creating a New DB2 OTD

Select Wizard Type

Connecting to a Database

Selecting Database Objects

Selecting Table/Views/Aliases

Selecting Procedures

Add Prepared Statements

Specifying the OTD Name

To Specify the OTD Name

Reviewing Selections

Editing Existing OTDs

To Edit an Existing OTD

Creating a DB2 Connect OTD

Select Wizard Type

Connecting to Database

Selecting Database Objects

Selecting Table/Views/Aliases

Selecting Procedures

Adding Prepared Statements

Specifying the OTD Name

Review Selections

Editing Existing OTDs

To Edit an Existing OTD

Creating a New Informix OTD

Select Wizard Type

Connect To Database

Select Database Objects

Select Tables/Views/Aliases

Select Procedures

Add Prepared Statements

Specify the OTD Name

Review Selections

Steps to Edit an Existing Informix OTD

Steps to Edit the OTD from the Java CAPS IDE Include:

Creating a New JDBC OTD

Select Wizard Type

To Connect To Database

Select Database Objects

Select Tables/Views/Aliases

Select Procedures

Add Prepared Statement

Specify the OTD Name

Review Selections

Editing an Existing JDBC OTD

To Edit the OTD from the Java CAPS IDE

Creating an Oracle OTD

Select Wizard Type

Connect To Database

Select Database Objects

Select Tables/Views/Aliases

Select Procedures

Add Prepared Statement

Specify the OTD Name

Review Selections

Creating a New SQL Server OTD

Select Wizard Type

Connect to Database

Select Database Objects

Select Table/Views/Aliases

Select Procedures

Add Prepared Statements

Specify the OTD Name

Review Selections

Editing Existing OTDs

To Edit an Existing OTD

Creating a New Sybase OTD

Select Wizard Type

To Connect to Database

Select Database Objects

Select Tables/Views/Aliases

Select Procedures

Add Prepared Statement

Specify the OTD Name

Review Selections

Editing an Existing Sybase OTD

To Edit the OTD from the Java CAPS IDE

Creating a VSAM OTD

Select Wizard Type

Connect To Database

Select Database Objects

Select Tables/Views/Aliases

Add Prepared Statement

Specify the OTD Name

Review Selections

Using the OTD Importer in Netbeans

Developing OTDs for Web Server Adapters

Designing with Application Adapters

Designing with Communication Adapters

Designing with Web Server Adapters

SWIFT Integration Projects

Java EE Based Components

Designing with Sun JCA Adapters

About the TCP/IP JCA Adapter

Defining Constants and Variables

Using Database Operations

Developing Sun Master Indexes

Using the JMS JCA Wizard

Using the JAXB Wizard and Code-Seeder Pallete

Select Tables/Views/Aliases

Select the types of tables or views required in the OTD.

Note - Aliases are not supported in the current release of the Oracle Adapter.

To Select Table/Views/Aliases

In the Select Tables/Views/Aliases window, click Add (see the figure below).
In the Add Tables window, select the type of criteria to be used for your search, consisting of table data, view only data, or both. You can include system tables in your search by selecting the checkbox.
From the Table/View Name drop down list, select the location of your database table and click Search. You can search for Table/View Names by entering a table name. The use of wildcard characters of ”?’, and ”*’ as part of your Table/View name search allow for greater search capabilities. For example, “AB?CD” or “AB*CD”.
Select the table of choice and click OK. The table selected is added to the Selected window (see the figure below).
On the Selected Tables/Views window, review the table(s) you have selected. To make changes to the selected Table or View, click Change. If you do not wish to make any additional changes, click Next to continue.
If you clicked Change on the Selected Tables/Views window, you can select or deselect your table columns on the Table/View Columns window. You can also change the data type for each table by highlighting the data type and selecting a different one from the drop down (see the figure below).
Click Advanced to change the data type, precision/length, or scale. In general, do not change the precision/length or the scale. Once you have finished your table choices, click OK (see the figure below).
When using Prepared Statement packages, select Use fully qualified table/view names in the generated Java code.