Contents of character positions
SELECT key1, key2, .... keyn FROM table_name
WHERE
where ‘key1’, ‘key2’, …. ‘keyn’ are the names of the columns which are used
to establish a unique key for each row in the database, ‘table_name’ is the name of the DB2 table which is to be processed by the utility, (ie. the name of the table itself, not the view of the table created during product installation processing), and
SELECT ACCOUNT, SUBCODE FROM OTDBTEST.TAB1
WHERE ACNO = ‘123456789’
Note that
The
12.In these circumstances, the SQL statement should be corrected and the job restarted.
Print reports
The
•Parameter specification and validation report. This will contain a list of SYSIN parameters specified (or defaulted) for execution of the utility, and a validation error report if errors are detected in parameter specification. It will also specify the SQL
•Execution report. Any errors or warning conditions encountered during execution of the utility will be identified in this report.
•Detail processing report. If PRINT=DETAIL has been specified (or allowed to default) in the execution parameter file, a detail print line will be written for each
o Request type (add to batch, or process batch) o Archive Manager database identifier
DB2 Manager User Guide | 103 |
StorageTek Proprietary |
|