WebSphere logo Classic Federation Server for z/OS, Version 9.1
WebSphere logo Classic Replication Server for z/OS, Version 9.1
WebSphere logo Classic Data Event Publisher for z/OS, Version 9.1
WebSphere logo Data Integration Classic Connector for z/OS, Version 9.1


Creating sequential tables and views for Classic federation

To query or update data in a sequential file, you must create a relational table that maps to that file. You can also create a view on the table to filter record types or filter rows and columns. You use the New Sequential Table wizard to create the table and optionally the view.

Before you begin

Restrictions

About this task

Classic federation uses two methods to physically access a sequential file:
  • The table definition can refer to the data set name. This method requires the data server to issue dynamic allocation requests before the file is physically opened. For Classic Federation to use dynamic allocation, the file must be cataloged.
  • The table definition can reference the file by DD (statement) name. Accessing the file by DD name requires that the file is statically and permanently allocated to the server address space because the referenced DD statement must be added to the server JCL, and the DSN parameter on the DD statement identifies the physical file to be accessed.

The recommended technique is to use dynamic allocation to access a sequential file. When a file is dynamically allocated, the file disposition is share mode, which allows other applications to access the file concurrently, if the applications are not attempting to access the file in exclusive mode.

For more information about creating tables and views that map to sequential files, see the related links for sequential syntax diagrams and for views.

Procedure

To create a sequential table and optionally a view for Classic federation:

  1. Map your sequential file to a relational table and optionally a view by using the New Sequential Table wizard.
    1. Open this wizard by right-clicking either the database in your data design project or one of the schemas within the database. Select Add Classic Object > Sequential table.
    2. Select the copybook or include file to base the table on.
    3. Choose whether to create a view on the table.
    4. Provide information about how to access the sequential file.
    5. Select the elements to map to columns in your relational table.
    6. If you are creating a view, specify the criteria for the WHERE clause.
    When you finish the wizard, the new table appears under the selected schema. If you created a view, the view also appears under the selected schema.
  2. Optional: Modify the table properties or add privileges. Select the table and make any changes in the Properties view.
  3. Optional: Generate the DDL for the table. You can generate the DDL later, if you do not want to generate it now. You can also generate the DDL for all of the objects within the same schema. See Generating DDL.
    1. Right-click the table and select Generate DDL.
    2. In the Generate DDL wizard, follow these steps:
      1. Choose to generate CREATE statements.
      2. Choose to generate DDL for tables.
      3. Name the file in which to save the DDL within your project.
      4. Choose whether to run the DDL on a data server. After running the DDL, check the Data Output view to determine whether the DDL ran successfully.
      5. Choose whether to open the DDL for editing.
  4. Optional: If you ran the DDL successfully on a data server, validate the table by running a test query against your sequential file. Be sure that the data server is connected to the system where the sequential file is located.
    1. In the Database Explorer, search your data server for the schema that you created the table in. Expand the schema and expand the Tables folder.
    2. Right-click the table and select Data > Sample Contents.
    3. Check the Data Output view to determine whether the test query ran successfully.
  5. Optional: If you created a view, generate the DDL for the view. You can generate the DDL later. You can also generate the DDL for all of the objects within the same schema. See Generating DDL.
    1. Right-click the view and select Generate DDL.
    2. In the Generate DDL wizard, follow these steps:
      1. Choose to generate CREATE statements.
      2. Choose to generate DDL for views.
      3. Name the file in which you want to save the DDL within your project.
      4. Choose whether to run the DDL on a data server. After you run the DDL, check the Data Output view to find out whether the DDL ran successfully.
      5. Choose whether you want to open the DDL for editing.
  6. Optional: If you ran the DDL successfully on a data server, validate the view by running a test query against your sequential file. Be sure that the data server is connected to the system where the sequential file is located.
    1. In the Database Explorer, search your data server for the schema that you created the view in. Expand the schema and expand the Views folder.
    2. Right-click the view and select Data > Sample Contents.
    3. Check the Data Output view to find out whether the test query ran successfully.
Related concepts
Mapping data for Classic federation
Array processing
Creating views on existing tables
Viewing and modifying objects
Populating metadata catalogs
Related tasks
Creating Adabas tables and views for Classic federation
Creating CA-Datacom tables and views for Classic federation
Creating CA-IDMS tables and views for Classic federation
Creating CICS VSAM tables and views for Classic federation
Creating tables and views for DB2 for z/OS databases
Creating IMS tables and views for Classic federation
Creating VSAM tables and views for Classic federation
Creating indexes
Modifying the PCB selection for IMS tables or indexes
Creating stored procedures
Adding or replacing columns in tables based on data definition files
Related information
Views


Feedback

Update icon Last updated: 2007-07-11