Start of change

Creating a feed in IBM® Mashup Center with data from a DB2 for z/OS server

You can create enterprise database feeds based on data from a DB2® for z/OS® server. A feed is data that is provided in a format that facilitates frequent content updates.

Before you begin

Introductory concepts
  • Install Mashup Center on a computer that is accessible from the DB2 for z/OS server.
  • Configure the Mashup Center server for DB2 for z/OS.

Procedure

To create a feed based on DB2 for z/OS data:

  1. In the MashupHub component of Mashup Center, click Create > New Feed and select the Enterprise Database (JDBC) feed generator.
  2. In the SQL Query Builder window, create the SQL query for the feed. The SQL parameters become the feed parameters. Parameters in the format ':arg' are treated as string parameters. Parameters in the format :arg are treated as numeric parameters. Supported SQL statements are SELECT, INSERT, UPDATE, and DELETE.
  3. Save the feed and click View Feed in Browser to execute the SQL statement.

Results

After you create the feed, you can do one or more of the following actions:
  • Create more feeds based on DB2 for z/OS data and then mix the results of the queries in a data mashup. A data mashup is a feed that you create by applying operators and functions to filter and restructure the source data. Use the data mashup builder in MashupHub to create a data mashup.
  • Add the feed to the Lotus® mashup builder. When you add a feed to the Mashup builder, the feed is added as a widget. A widget is a small application or piece of dynamic content that can be easily placed on a web page. Mashable widgets pass events so that they can be wired together to create something new.
  • Add the feed to another application by using the "Add to" action.
  • Share the feed in the Mashup Center community catalog so that other users can include it in their mashups. Users can tag and rate catalog objects to help others find the information that they need quickly.
End of change