Previous Topic

Next Topic

Book Contents

Book Index

General Information

FIRSTKEY and LASTKEY should be composed of a concatenation of fields only of the following types:

Table 269 Legal Field Types for Composition of FIRSTKEY and LASTKEY Fields

Type

Description

Alphanumeric string

C‘aaa’ (for example, C‘TOTAL1’)

Hexadecimal

X‘nnnn’ (for example, X‘12AB’), where ‘nnnn’ must be an even number of digits.

Note: For packed decimal and/or zoned decimal support, use the hexadecimal representation of these numbers.

The key value is created by concatenation of the strings. This way, a key that contains both alphanumeric and hexadecimal strings can be specified.

If the specified key is shorter than the actual KEYLEN of the VSAM file, the specified key is padded by hexadecimal ‘00’ characters for FIRSTKEY and hexadecimal ‘FF’ characters for LASTKEY. This enables GENKEY access.

The output of ON VSAM is identical to the output of the IDCAMS REPRO command, specified with similar parameters (for example, you can extract the information with reference to the original columns in the VSAM file in accordance with the record layout). Please refer to the IBM VSAM Administration Guide for additional information on the REPRO command.

Parent Topic

ON VSAM: Data Selection Statement