Define alternate index vsam file

Quite often, to reach larger markets or provide a higher level of service to existing customers it requires the newer Internet technologies to work in a complementary manner with existing corporate mainframe systems. We specialize in preparing applications and the associated data that are currently residing on a single platform to be distributed across a variety of platforms. Preparing the application programs will require the transfer of source members that will be compiled and deployed on the target platform.

The data will need to be transferred between the systems and may need to be converted and validated at various stages within the process. SimoTime has the technology, services and experience to assist in the application and data management tasks involved with doing business in a multi-system environment. Table of Contents. Program Requirements. Quick Start, Run Sample Programs.

Mainframe Oriented Environment. Windows Oriented Environment. The JCL Members. Define the Alternate Index. Build the Alternate Index. Use the Primary Key and Print Report. Use the Alternate Key and Print Report. Use Either Key and Print Report. The CMD Members. Read Indexed File Sequential by Key. Use the Either Key and Print Report.

Software Agreement and Disclaimer. Downloads and Links. Current Server or Internet Access. Internet Access Required. Glossary of Terms. Comments or Feedback. Company Overview.

The SimoTime Home Page. Demonstrate how to load or populate and empty KSDS and build the alternate index. Demonstrate how to read the KSDS sequentially by the primary key and print a report. Demonstrate how to read the KSDS sequentially by the alternate index and print a report. Operating System Alternatives. JCL Name. This job will create the VSAM cluster, populate with data and create an alternate index. This job demonstrates how to randomly add new records or update existing records in a KSDS with an alternate index.

This is an optional step. The customer number is the primary key. The telephone number is the alternate index. This job uses a COBOL program to print a simple report that may be sequenced by customer number or telephone number depending on a parameter passed from the JCL.

The customer number is the primary key and the telephone number is the alternate index. Sequence of Jobs for a Mainframe Oriented Environment. Sequence of Jobs for a Windows Oriented Environment. Depending on what really is the requirement, you may need more than one alternate index.

I need to access only region field USA in above example. For this i need to give a key but i am confused to count space or not. Kind regards gyaa. View previous topic :: View next topic. Posted: Tue Jul 19, pm. HI, Hi, I have the following two questions: 1.

How to define the record size in alternate cluster definition, should it be the same as in the base cluster. Is there any other criteria 2. Is it possible to read a vsam file using alternate index. Thank u. Back to top. Hi thanooz, Can u give me some sample Cobol code. Ur first answer cleared my doubt but my second question remains unanswered.

Posted: Wed Jul 20, am. Hi, What should be assigned to dd1 in jcl: Path name or base cluster name or the alternate index cluster name. Hi, Its Path name Corrections are welocome.. Hi, I have a problem in opening the file when using the path name. But I am able to read without any error while reading from the base cluster without using alternate key. Is there any particular syntax for opening the file and reading it while using alternate key.