DB2 Server for VSE & VM: Data Restore Guide

Description

Figure 128 shows an overview of the SELECT function. Make sure that the CREATOR and the TNAME parameters define a table, not a view. You can use the SELECT function to extract data from any table without LONG columns. Make sure you can access the dbname SQLDEF file on the database production disk.

Note:

When you select the SELECT function, Data Restore does not execute local date and time user exits nor does it execute field procedures on the selected columns.

Figure 128. Overview of the SELECT function

SYSIN

Contains the name of the table to select, the names of the columns to select and the output device. You can use one SELECT statement in the SYSIN file.

SELECT

Is the function to process to access data.

OUTPUT

Contains the result of the SELECT function. The DBAPW parameter of the CONTROL statement appears as asterisks in the output.

DATAUNL files

Contain data when OUTPUT=TAPE/DASD is specified.