DB2 Server for VSE & VM: Data Restore Guide

Using the SELECT Function in a VSE Environment

Figure 129 shows an example of JCL to execute the SELECT function.

Figure 129. JCL to Execute a SELECT Function (VSE)

// JOB SELECT (1) ---> // LIBDEF *,SEARCH=(PRD2.DB2vrm,PRD2.RCVvrm) (2) ---> // EXEC PROC=ARIS71DB (3) ---> // EXEC XTS91001,SIZE=AUTO (4) ---> CONTROL DBAPW=XXXXXXXX (5) ---> SELECT CREATOR=SQLDBA TNAME=CUSTOMERS (6) ---> COLUMNS=(CUST_NO, CUST_NAME, CUST_ADDRESS) (7) ---> /*

Statement 1

Specifies the DB2 library. You must specify the DB2 library for the SELECT function.

Statement 2

Uses an EXEC to access the database files.

Statement 3

Processes the function.

Statement 4

Specifies the SQLDBA password.

Statement 5

Indicates the creator name as well as the table name.

Statement 6

Indicates the column name criteria for selection.

Statement 7

Ends the SYSIN file.