DB2 Server for VSE & VM: Data Restore Guide

SELECT



>>-SELECT----CREATOR=creator---TNAME=tname---------------------->
 
>-----+-----------------------------+--------------------------->
      |              .-,-------.    |
      |              V         |    |
      '-COLUMNS=--+----cname---+-+--'
                  '-colno--------'
 
>-----+------------------------+---+-----------+---------------><
      |          .-PRINTER--.  |   '-COUNT=nnn-'
      '-OUTPUT=--+-TAPE-----+--'
                 '-DASD-----'
 

Purpose

The SELECT command lets you select data from DB2 tables directly out of the dbextents, bypassing the database manager.

Operands

CREATOR
The name of the creator of the table.

TNAME
The name of the table which will be selected

COLUMNS
The specific columns to be selected. It can list either column name(s) or column number(s). If you omit the COLUMNS= parameter, all columns are selected.

OUTPUT
The output device:

PRINTER The output file is spooled to the printer. This is the default.

TAPE The output file is a tape file

DASD The output file is a disk file

COUNT
The specific number of rows to be selected (from 1 to 32000).


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]