Module 1: Querying and modifying data

You can interactively query and modify data that is stored in Db2 for z/OS® by issuing SQL statements through SPUFI.

Learning objectives

This tutorial shows you how to do the following tasks:

Issue SQL statements by using SPUFI
Query data in Db2 tables and view results
Modify data in Db2 tables and verify the changes
Create objects

Time required

45 minutes.

Before you begin

Complete the prerequisites that are listed in the introduction to this tutorial.
Log on to z/OS by using a TSO session.
Create or obtain access to a partitioned data set to contain your work. Contact your system administrator to find out the conventions for data sets at your site, or accept the default values. This tutorial assumes that the data set is named USER.SRCLIB.TUTORIAL.