The following tables show the required FMT statements used for VSAM KSDS, VSAM ESDS, VSAM RRDS, and VSAM PATH.
VSAM KSDS
In a sample employee database, the required FMT statements for a VSAM KSDS and the corresponding LISTCAT description might be as follows:
|
FMT statements |
LISTCAT description |
|---|---|
|
FMT NAME IS EMPFMT |
|
|
FILE TYPE IS KSDS |
INDEXED |
|
KEY LENGTH IS 44 |
KEYLEN----------------44 |
|
KEY POSITION IS 0 |
RKP------------------------0 |
|
VSAM RECORD LENGTH IS 805 |
MAXLRECL------------805 |
|
FILE IS NOT REUSABLE |
NOREUSE |
|
RECORD NAME IS EMPLOYEE |
|
|
SET NAME IS EMP-NDX |
|
VSAM ESDS
The required FMT statements for a VSAM ESDS and the corresponding LISTCAT description might be as follows:
|
FMT statements |
LISTCAT description |
|---|---|
|
FMT NAME IS DEPFMT |
|
|
FILE TYPE IS ESDS |
NONINDEXED |
|
VSAM RECORD LENGTH IS 17 |
MAXLRECL-------------17 |
|
FILE IS REUSABLE |
REUSE |
|
RECORD NAME IS DEPARTMENT |
|
|
SET NAME IS DEPT-NDX |
|
VSAM RRDS
The required FMT statements for a VSAM RRDS and the corresponding LISTCAT description might be as follows:
|
FMT statements |
LISTCAT description |
|---|---|
|
FMT NAME IS EXPFMT |
|
|
FILE TYPE IS RRDS |
NUMBERED |
|
RELATIVE RECORD NUMBER POSITION IS 9 |
|
|
VSAM RECORD LENGTH IS 9 |
MAXLRECL-------------9 |
|
RECORD NAME IS EXPERTISE |
|
|
SET NAME IS EXP-NDX |
|
VSAM PATH
The required FMT statements for a VSAM PATH and the corresponding LISTCAT description might be as follows:
|
FMT statements |
LISTCAT description |
|---|---|
|
FMT NAME IS MGTFMT |
|
|
FILE TYPE IS PATH |
|
|
BASE CLUSTER IS KSDS |
|
|
KEY LENGTH IS 8 |
KEYLEN----------------8 |
|
KEY POSITION IS 5 |
RKP----------------------5 |
|
VSAM RECORD LENGTH IS 17 |
MAXLRECL-----------17 |
|
FILE IS REUSABLE |
REUSE |
|
RECORD NAME IS EMPLOYEE |
|
|
SET NAME IS MANAGES-NDX |
|
|
Copyright © 2014 CA.
All rights reserved.
|
|