Steps and tasks

Defining a replication step

Defining a base aggregate replication step

Defining a change aggregate replication step

Defining a point-in-time replication step

Defining a staging table replication step

Defining a user copy replication step

Defining a statistical transformer

Obtaining variability estimates between or within groups

Calculating the running subtotal for numeric values grouped by period

Calculating common descriptive statistics

Performing chi-square tests

Determining the linear relationship between variables in two columns

Predicting the future course of time series values

Finding relationships and correlations between two variables

Defining a warehouse transformer

Cleaning data

Assigning key column values

Creating a period table

Inverting rows and columns in a table

Grouping related data from selected columns into a single column

Defining a Visual Warehouse 5.2 DB2 UDB program

Using a Visual Warehouse 5.2 program to export data from a local DB2 UDB database

Using a Visual Warehouse 5.2 program to load data from a flat file into a DB2 table, appending to existing data

Loading data from a flat file into a DB2 Common Server database, replacing existing data

Using a Visual Warehouse 5.2 program to run the DB2 Reorg utility

Using a Visual Warehouse 5.2 program to run the DB2 RUNSTATS utility

Using a Visual Warehouse 5.2 program to load data from a delimited flat file into a DB2 UDB EEE database, replacing existing data

Defining a file program

Copying files to and from a remote host

Writing data from a database registered in ODBC to a delimited file

Submitting an MVS JCL jobstream

Transferring files using FTP

Defining an OLAP program

Calling the default calc script associated with the target OLAP Server database

Applying a specified calc script to an OLAP Server database

Loading data from a flat file into a DB2 OLAP Server database using free-form data loading

Loading data from an SQL source into a DB2 OLAP server database

Loading data from a flat file into a multidimensional DB2 OLAP Server database without using load rules

Updating an OLAP Server outline from a flat file

Updating an OLAP Server outline from an SQL source

Defining SQL

Defining a step that uses SQL

Defining a DB2 UDB Program

Exporting data from a table or view

Loading data into a table

Reorganizing a table

Running statistics on a table

Defining a DB2 UDB for OS/390 Program

Updating DB2 for OS/390 table space statistics

Reorganizing a table space

Loading data into tables of a DB2 for OS/390 table space

Defining a DB2 UDB for AS/400 Program

Loading data from a flat file into a DB2 UDB for AS/400 table, appending to existing data

Loading data from a flat file into a DB2 UDB for AS/400 table, replacing existing data

Defining a step that runs a User-Defined Program

Defining a step that runs a user-defined program