Creating a relational record list as a page data object

This section describes how to create a relational record list in the Page Data view.
Note: Some Faces Client Components and Client Data have been deprecated and are not recommended for use.
The following have been deprecated and are not recommended for use:
  • Client Data and its associated tooling (such as the Client Data view)
  • Faces Client Components
    • <odc:dataGrid> (Data Grid)
    • <odc:webService> (Web Service)
    • <odc:clientData>
    • <odc:clientBinder>
  1. In the Web Perspective, open the JSP page.
  2. Right-click in the Page Data View, and select New > Relational Record List.
  3. In Relational Record List wizard, type emp in the Name field, and click Next.
  4. In the Record List Properties dialog, click New to create a new connection.
  5. Type emp_con in the Name field, and click Next.
  6. In the New Connection dialog, type Sample in the Database field.
  7. In the Select A Database dialog, select Use Live Connect, and click Create new DB Connection.
  8. In the Establish a connection to a database dialog, select Choose a DB2 alias, click Next.
  9. In the Specify connection parameters dialog, change the JDBC driver to IBM DB2 Application and Alias to SAMPLE, and click Finish.
  10. In the Record List Properties dialog, select EMPLOYEE table, and click Next.
  11. In the Column selection and other tasks dialog, select EMPNO as the primary key, using the Modify primary key task, click Finish. emp (EMPLOYEE) will appear on the Page Data view
    Note: When you define the primary key in the Record List Properties dialog, you must correctly specify the primary key. If your primary key is not unique or incorrect, you will receive unpredictable results. You must specify a primary key in the Record List Properties dialog when it is not defined in the database.
Related tasks
Creating a client data object
Adding a data grid

Feedback