How to define PATH

PATH establishes a relation between the base cluster and the alternate index. Its not a data set and does not occupy any space. It does not contain any records. It is justa a entry in the catalog, which establishes a link between the base cluster and the alternate index cluster. //PATHDEF JOB (ACCT),’DEFINE PATH’ //DEFPATH…

Details

How to define Alternate Index

Alternate Index is a cross reference to a base table. The JCL to allocate the Alternate Index is as shown below. //AIXDEF JOB (ACCT),’AIX DEFINE’ //ALLOCATE EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=* //SYSIN DD * DEFINE AIX – (NAME(STUDENT.KSDS.AIX.CLUSTER) – (RELATE(STUDENT.KSDS.CLUSTER) – VOLUMES(XXXXXX) – CYLINDERS(5,1) – CONTROLINTERVALSIZE(2048) – FREESPACE(10,20) – KEYS(10,6) – NONUNIQUEKEY – UPGRADE –…

Details

Printing Datasets

//PRNTEXM JOB (ACCT), ‘PRINT JOB’ //PRINT EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=* //INPUT DD DSN=STUDENT.TEST.INPUT, DISP=OLD //SYSIN DD * PRINT                             – INFILE (FILENAME)  – SKIP (2)                          – COUNT (4)                     – CHAR /* //  The PRINT command is used to print VSAM and NON VSAM data sets. It dumps the contents of input file to an…

Details

FROMKEY and TOKEY

REPRO                                                                      – INDATASET(STUDENT.TEST.INPUT)             – OUTDATASET(STUDENT.KSDS.CLUSTER)   – FROMKEY(100000) TOKEY(500000) This command will copy all records with key values ranging from 100000 to 500000. The range can also be generic (Eg. FROMKEY (10)  TOKEY(50)). This will copy all records in input file with 10 as the first two bytes of the key through the records having 33 as…

Details