Create a Relational Record List as a Page Data Object

 

+
Search Tips   |   Advanced Search

 

1. Switch to the Web Perspective

2. Go to...

   JSP page | Page Data View (right-click) | 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, 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.