DB2 Server for VSE & VM: Data Restore Guide

Chapter 16. Command Syntax

All commands start in column 1. If the statement is longer than one line, continue the statement on the next line starting after a column position other than 1.

You can use a mixture of both upper or lower case.

To include comments in the SYSIN file, enter an asterisk (*) as the first character on the line.

You can separate parameters with either a space or comma.

The SYSIN report is sent to the printer device and shows all the input control records used to execute the function.

An example SYSIN file that processes a Data Restore function is shown in Figure 156. (This example reloads a table named CUSTOMERS created by SQLDBA.)

Figure 156. Example SYSIN File to Process a Data Restore Function

(1) ---> OPTIONS DEVICE=TAPE LANG=S002 (2) ---> CONTROL DBNAME=SQLDBA (3) ---> RELOAD CREATOR=SQLDBA TNAME=CUSTOMERS (4) ---> FUNCT=NEW (5) ---> * RELOAD CREATOR=SQLDBA TNAME=EMPLOYEE

Statement 1

Specifies the OPTIONS statement starts in column 1. You must define the OPTIONS statement on the first line of the SYSIN file.

Statement 2

Specifies the CONTROL statement which starts in column 1 and must follow the OPTIONS statement.

Statement 3

Identifies the function starting in column 1. The function definition must follow the OPTIONS and CONTROL statements.

Statement 4

Continues the statement started on the preceding line. Note that the statement does not start in column 1.

Statement 5

Uses an asterisk in column 1 to indicate a comment.