DB2 Server for VSE & VM: Data Restore Guide

Using the SELECT Function in a VM Environment

Figure 130 shows an EXEC to execute the SELECT function.

Figure 130. Procedure to Execute a SELECT Function (VM)

/**/ (1) ---> 'FILEDEF SYSPRINT DISK SELECT SYSPRINT A' (2) ---> 'FILEDEF SYSIN DISK SELECT SYSIN A' (3) ---> 'XEDIT SELECT SYSIN A' (4) ---> 'XTS91001'

Statement 1

Designates the SYSPRINT file to contain information about the process.

Statement 2

Specifies the SYSIN file.

Statement 3

Initiates an edit of the SYSIN file to allow for any changes before processing.

Statement 4

Starts the program to process the function.

The SYSIN file must contain the following statements:

Figure 131. SYSIN File to Specify Table Selection

(5) ---> CONTROL DBAPW=XXXXXXXX, DBNAME=dbname (6) ---> SELECT CREATOR=SQLDBA TNAME=CUSTOMERS (7) ---> COLUMNS=(CUST_NO, CUST_NAME, CUST_ADDRESS)

Statement 5

Specifies the database to process and the SQLDBA password.

Statement 6

Indicates the creator name and the table name.

Statement 7

Indicates the column name criteria for selection.

Make sure you can access the dbname SQLFDEF file on the database production disk when you execute Data Restore.