Non-Relational Data Connection
 File Accessing Methods, Utility Programs and SORT
When technology complements business    Copyright © 1987-2013  SimoTime Enterprises  All Rights Reserved
  Table of Contents Version 12.11.21 
  Introduction
  Status Codes and Common Utility Programs
  File Status Codes, Reference Document
  File Status Codes, Populate a KSDS with Code Information
  File Status Codes, Program Example, Format and Display
  Utility Programs - Create, Update or Delete a File or VSAM Data Set
  VSAM Programming Examples
  VSAM, Keyed Sequential Data Sets (KSDS), Programming Examples
  VSAM, KSDS processing with a Single COBOL Program
  VSAM, KSDS processing using COBOL with a COBOL I/O Routine
  VSAM, KSDS processing using COBOL with an Assembler I/O Routine
  VSAM, Entry Sequential Data Sets (ESDS), Programming Examples
  VSAM, ESDS Delete, Define with JCL & Add Records using COBOL
  VSAM, Relative Record Data Sets (RRDS), Programming Examples
  VSAM, RRDS Delete, Define with JCL & Add Records using COBOL
  QSAM Programming Examples
  QSAM processing with a Single COBOL Program
  QSAM File processing using COBOL with a COBOL I/O
  QSAM processing using COBOL with an Assembler I/O Routine
  Sequential File Format with CSV Record Content
  Create a New Sequential File with CSV Record Content
  Access an Existing Sequential File with CSV Record Content
  Sequential Files with Variable Length Records
  Variable Length Records (process using Standard COBOL)
  Variable Length Records (using Byte-Stream I/O)
  Variable Length Records (Transfer, Share, Convert, Compare)
  ASCII/Text to Record Sequential with Variable Length Records
  Data File Information Collection
  Data Allocation and Access Methods
  Managing Partitioned Data Sets (PDS's)
  Generation Data Groups (GDG's)
  Working with Concatenated Data Sets
  Alternate Index for VSAM, KSDS
  Sort a File
  SORT, Mainframe Example using JCL
  SORT, Mailing Labels, Postal Code Sequence
  SORT, Simple Examples for Mainframe and Micro Focus
  SORT, How to use a COBOL Program to call SORT
  The SimoCARD Series, Sequential File Access, 80-Bytes
  Data Management Series, White Papers
  Data File Abstract
  Data File Transfer
  Data File Conversion
  Data File Comparison (or Validation)
  File Formats for Micro Focus
  Data File Transfer, Share, Convert or Compare
  Data File Compare, a User's Guide
  Compare - Basic Function, A Simple 80/80 Compare
  Compare - Moderate Function, Customer File with Partial Record Compare
  Compare - Advanced Function, Report File Compare with Compaction and Bypass Capability
  Compare Files with Variable-Length Records
  Compare Positions Defined at Execution Time for Variable-Length Records
  Compare with a Call to Convert
  Data File Convert, a User's Guide
  Convert - Basic Function, A Simple 80/80 Convert
  Convert - Moderate Function, Customer File Conversion with Packed and Binary Data
  Convert - Advanced Function, Convert Fixed Field to Comma Separated Values for Excel
  Convert - Miscellaneous Programs
  A Simple EBCDIC to ASCII File Content Conversion
  Convert between Line & Record Sequential, EBCDIC & ASCII
  Convert between Comma-Separated-Values and Fixed-Field-Lengths
  File Format and Record Content Conversion including Field Expansion
  Data File Confirm or Verify
  Calculate Record Counts and Summary Totals
  Calculate Record Counts and Summary Totals for an Item Master File
  Data File Management and Manipulation with Miscellaneous Examples
  A File Format Conversion from Mainframe Image with Variable Length Records
  A Data File Transition Cycle with Various Convert and Compare Processes
  Various Data File Create, Convert, Copy and Compare Examples
  Data File Processing with Multiple Record Types
  Micro Focus Environment
  File Formats for Micro Focus
  Micro Focus, Compiler Directives
  Micro Focus, Creating & Processing Large Files (greater than 2-gig)
  Micro Focus, Baseline Elapsed Timings (Small, Medium and Large Files)
  Micro Focus, Dynamic File Allocation
  Micro Focus, Populate a Catalog
  Micro Focus, Extract File Information from JCL
  The Customer Master File
  Customer Master, Create and Populate a Test File
  Customer Master, Extract and Format Data for Excel
  Customer Master, Convert between EBCDIC and ASCII
  Customer Master, Create and Populate, Generic Name and Address
  Customer Master, Convert from EBCDIC to ASCII
  The Item Master File
  Item Master, Extract and Format Data for Excel
  Item Master, Convert between EBCDIC and ASCII
  Repository Management Programs
  Repository for Application Properties
  Repository for File Properties
  Repository for File Status Codes
  Summary
  Software Agreement and Disclaimer
  Downloads and Links to Similar Pages
  Downloads and Links, Internet Access Required
  Glossary of Terms
  Comments, Suggestions or Feedback
  Company Overview
The SimoTime Home Page

Table of Contents Previous Section Next Section Introduction

The Non-Relational Data Connection provides a suite of sample programs and reference documentation for managing VSAM Data Sets or flat, sequential files (QSAM). Processing principles and techniques for creating, deleting or updating are included for both VSAM and QSAM. The sample members are written to run as MVS batch jobs on an IBM mainframe or as a project with Micro Focus Mainframe Express (MFE) running on a PC with Windows. If a technique is used that is unique to the mainframe and not supported by Mainframe Express it will be noted.

Table of Contents Previous Section Next Section Status Codes and Common Utility Programs

This section is intended for individuals that are learning, creating or maintaining applications that access VSAM Data Sets. Sample programs are provided and most samples will run on an IBM Mainframe or Micro Focus Mainframe Express platform.

Table of Contents Previous Section Next Section File Status Codes, Reference Document

The ANS/85 standard provides for a two-byte file-status-key. The first character of the file-status-key is known as status-key-1. The second character is known as status-key-2.

The combinations of possible values and their meanings are shown in the File Status Codes Documents with some comments where vendor additions or extensions may occur.

Table of Contents Previous Section Next Section File Status Codes, Populate a KSDS with Code Information

This example will use IEBGENER to create a sequential file. This file will be used by IDCAMS to populate a VSAM, KSDS. The KSDS will information about file status codes.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section File Status Codes, Program Example, Format and Display

This COBOL programming example will show how to display the file status code by converting the two byte file status code that may contain binary data to a four byte numeric value. This example contains two COBOL programs. The first is a demonstration program that generates various two byte, file status codes. The second COBOL routine does the actual conversion to a four byte, numeric value that may be displayed. A brief description of the file status code is also provided.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Utility Programs - Create, Update or Delete a File or VSAM Data Set

This suite of programs will create, populate and delete the QSAM file and the VSAM, KSDS data set used by many of the sample programs. Sample mainframe JCL and a sample COBOL program are included.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section VSAM Programming Examples

This section is intended for individuals that are learning, creating or maintaining applications that access VSAM Data Sets. Sample programs are provided and most samples will run on an IBM Mainframe or Micro Focus Mainframe Express platform.

Table of Contents Previous Section Next Section VSAM, Keyed Sequential Data Sets (KSDS), Programming Examples

The following describes how to create or maintain applications that access VSAM Key Sequenced Data Sets (KSDS). Sample programs are provided and most samples will run on an IBM Mainframe or Micro Focus Mainframe Express platform.

Table of Contents Previous Section Next Section VSAM, KSDS processing with a Single COBOL Program

This program suite provides an example of how a single COBOL program is used to access a VSAM data set. The COBOL programs are written using COBOL/2 dialect but also works with COBOL for MVS and COBOL/370.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section VSAM, KSDS processing using COBOL with a COBOL I/O Routine

This program suite provides an example of how a single COBOL program is used to access a VSAM data set. The COBOL programs are written using COBOL/2 dialect but also works with COBOL for MVS and COBOL/370.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section VSAM, KSDS processing using COBOL with an Assembler I/O Routine

This program suite provides an example of how a mainline COBOL program calls a mainframe Assembler I/O routine to access a VSAM data set. The COBOL program is written using the COBOL/2 dialect but also work with COBOL for MVS and COBOL/370. The assembler IO routine is written in IBM Mainframe Assembler, it will compile using Assembler/H or HLASM.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section VSAM, Entry Sequential Data Sets (ESDS), Programming Examples

The following describes how to create or maintain applications that access VSAM Entry Sequenced Data Sets (KSDS). Sample programs are provided and most samples will run on an IBM Mainframe or Micro Focus Mainframe Express platform.

Table of Contents Previous Section Next Section VSAM, ESDS Delete, Define with JCL & Add Records using COBOL

This program suite provides an example of how to delete and define a new Entry Sequenced Data Set (ESDS) using Mainframe JCL. Once the new ESDS is created a COBOL program is used to add records to the data set.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section VSAM, Relative Record Data Sets (RRDS), Programming Examples

The following describes how to create or maintain applications that access VSAM Relative Record Data Sets (RRDS). Sample programs are provided and most samples will run on an IBM Mainframe or Micro Focus Mainframe Express platform.

Table of Contents Previous Section Next Section VSAM, RRDS Delete, Define with JCL & Add Records using COBOL

This program suite provides an example of how to delete and define a new Relative Record Data Set (RRDS) using Mainframe JCL. Once the new RRDS is created a COBOL program is used to add records to the data set.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section QSAM Programming Examples

This section is intended for individuals that are learning, creating or maintaining applications that access QSAM Files. Sample programs are provided and most samples will run on an IBM Mainframe or Micro Focus Mainframe Express platform.

Table of Contents Previous Section Next Section QSAM processing with a Single COBOL Program

This program suite provides an example of how a single COBOL program is used to access a QSAM or Sequential file. The COBOL programs are written using COBOL/2 dialect but also works with COBOL for MVS and COBOL/370.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section QSAM File processing using COBOL with a COBOL I/O

This program suite provides an example of how a mainline COBOL program calls a mainframe COBOL I/O routine to access a QSAM or Sequential file. The I/O routine will also display the file status codes when an I/O error occurs. The COBOL programs are written using the COBOL/2 dialect but also work with COBOL for MVS and COBOL/370.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section QSAM processing using COBOL with an Assembler I/O Routine

This program suite provides an example of how a mainline COBOL program calls a mainframe Assembler I/O routine to access a QSAM sequential file. The COBOL program is written using the COBOL/2 dialect but also work with COBOL for MVS and COBOL/370. The assembler IO routine is written in IBM Mainframe Assembler, it will compile using Assembler/H or HLASM.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Sequential File Format with CSV Record Content

This section provides information and links to documents and examples for creating and accessing sequential files with a record structure of Comma-Separated-Values (CSV).

Table of Contents Previous Section Next Section Create a New Sequential File with CSV Record Content

This example describes how to create a sequential file with CSV formatted records.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Access an Existing Sequential File with CSV Record Content

This example describes how to access an existing sequential file with CSV formatted records.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Sequential Files with Variable Length Records

This program suite provides an example of how to create and access a sequential file containing variable length records. The COBOL programs are written using the COBOL/2 dialect but also works with COBOL for MVS and COBOL/370.

Table of Contents Previous Section Next Section Variable Length Records (process using Standard COBOL)

This program suite provides an example of how to create and access a sequential file containing variable length records using standard SELECT and FD statements. The COBOL programs are written using the COBOL/2 dialect but also works with COBOL for MVS and COBOL/370.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Variable Length Records (using Byte-Stream I/O)

This program suite provides an example of how to transfer and convert a sequential file containing variable length records. The example includes a description of how to use FTP to download a file without doing a conversion on the Mainframe System. The COBOL programs are written using the Micro Focus dialect and requires Micro Focus Net Express or Micro Focus Mainframe Express.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Variable Length Records (Transfer, Share, Convert, Compare)

This program suite provides an example of how to Transfer, Share, Convert and Compare record and line sequential files containing variable length records. The example includes a description of how to use FTP to download a file without doing a conversion on the Mainframe System. The COBOL programs are written using the Micro Focus dialect and requires Micro Focus Net Express.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section ASCII/Text to Record Sequential with Variable Length Records

The example will describe how to convert an ASCII/Text file (Line Sequential) to a Micro Focus Record Sequential file with variable length records. The COBOL program that does the file format conversion was generated using SimoTime Technology running on a Windows System and using Micro Focus COBOL.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Data File Information Collection

This example will use a Windows System running a Micro Focus sub-system to create a Key-Sequenced-Data-set containing an inventory of traditional sequential files and VSAM Data Sets. Once the inventory of files has been created it will be possible to use this information to build a catalog for Micro Focus Mainframe Express or Micro Focus Studio/Server environments.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Data Allocation and Access Methods

This group of documents and programs describes and demonstrates various approaches to allocating data resources to a job. Various processing or access methods are discussed based on the type of allocation and the file structure.

Table of Contents Previous Section Next Section Managing Partitioned Data Sets (PDS's)

This suite of programs provides examples of how to create PDS's.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Generation Data Groups (GDG's)

This suite of sample programs describes how to define a Generation Data Group (GDG). Once the GDG is defined the creation of a Generation Date Set (referred to as a generation or GDS) within the group is discussed. The COBOL program is written using the COBOL/2 dialect but works with COBOL for MVS and COBOL/370.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Working with Concatenated Data Sets

This suite of programs and documentation will describe and demonstrate the data set concatenation function provided with JCL, Utility Programs and COBOL. It is possible to process more than one data set as a single data set by concatenating the DD statements.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Alternate Index for VSAM, KSDS

This program suite provides an example of how a COBOL program can process a VSAM, Keyed Sequential Data Set (KSDS) with a primary key and an alternate index. The COBOL programs are written using the COBOL/2 dialect but work with COBOL for MVS and COBOL/370.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Sort a File

This section provides information and links to white papers and examples for using the SORT on an IBM Mainframe System or a Micro Focus environment running on a Windows, Linux or UNIX System.

Table of Contents Previous Section Next Section SORT, Mainframe Example using JCL

This suite of programs provides an example of how to do syntax checking of a JCL member without executing the job steps. The first two JOB steps use IEFBR14 to delete previously created files and then uses IEBGENER to create a new file. The next two JOB steps use the SORT utility to copy a file and to sort a file. A job step is included that will do a case insensitive sort.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section SORT, Mailing Labels, Postal Code Sequence

This suite of programs provides an example of how a mainline application processes a VSAM, KSDS or Indexed File containing Name, Address information and creates a sorted (by postal code sequence) sequential file containing mailing labels that are formatted with 1, 2, 3 or 4 labels across of six lines for each label. This example uses a two-dimensional array to build the label-printing output.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section SORT, Simple Examples for Mainframe and Micro Focus

This suite of programs will describe how to do use the Micro Focus SORT program with a Windows command line or Mainframe JCL. The Mainframe JCL will execute on a Mainframe System with ZOS. A small sequential file is created and then sorted.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section SORT, How to use a COBOL Program to call SORT

This suite of programs will describe and demonstrate by example how to use a COBOL program to call the SORT program to sort the records in a data file in ascending order by the surname that is located in positions 8-22.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section The SimoCARD Series, Sequential File Access, 80-Bytes

The SimoCARD Suite of Programs will provide read and write access to Record Sequential and Line Sequential data files consisting of eighty (80) byte records that have been downloaded from a mainframe using the File Transfer Protocol (FTP). The Record Sequential files are usually downloaded in BINARY mode and contain EBCDIC encoded data. The Line Sequential files are usually downloaded in ASCII mode and contain ASCII encoded data. In addition to the four I/O routines a fifth callable routine is provided that will convert eighty (80) byte text strings between ASCII and EBCDIC.

Note: A Line Sequential file may also be referred to as an ASCII/Text file.

Table of Contents Previous Section Next Section Data Management Series, White Papers

This section provides examples and links to documents that describe the management of data sharing or application migration between an IBM Mainframe System and a Windows System using Micro Focus. The information provided will cover data file transfer, conversion and comparison of non-relation or traditional sequential files and VSAM, Keyed Sequential Data Sets (KSDS). Click here for a Consolidated Look at the White Papers and Sample Programs provided by the Data Management Series.

Table of Contents Previous Section Next Section Data File Abstract

This is a link to a white paper that provides a Quick Overview of the Data Management Tasks required to migrate or share data between a Mainframe system and a Windows, Linux or UNIX system.

Table of Contents Previous Section Next Section Data File Transfer

This is a link to a white paper that provides a Quick Overview of the Data File Transfer options available when transferring or sharing data between a Mainframe system and a Windows, Linux or UNIX system.

Table of Contents Previous Section Next Section Data File Conversion

This is a link to a white paper that provides a Quick Overview of the Possible Data File Conversion options available when migrating or sharing data between a Mainframe system and a Windows, Linux or UNIX system.

Table of Contents Previous Section Next Section Data File Comparison (or Validation)

This is a link to a white paper that provides a Quick Overview of the Possible Data File Comparison options available when testing an application or data that has been moved between a Mainframe system and a Windows, Linux or UNIX system.

Table of Contents Previous Section Next Section File Formats for Micro Focus

This is a link to a white paper that provides a quick overview of the various Micro Focus File Formats provided for the Windows, Linux and UNIX environments supported by Micro Focus

Table of Contents Previous Section Next Section Data File Transfer, Share, Convert or Compare

This section provides examples and links to documents that describes the data file transfer, convert or compare of non-relation or traditional sequential files and keyed sequential data sets.

There are many options available when moving and converting data between an IBM Mainframe and a Linux, UNIX or Windows environment. This link provides an overview of the processes for file transfer and conversion with an example of how to convert a VSAM data set to a flat Sequential file on the Mainframe System. Using FTP the sequential file may be transferred from the Mainframe System to a Linux, UNIX or Windows (LUW) System. On the LUW System using Micro Focus technology along with SimoTime technology a new file of a compatible format of ASCII or EBCDIC content may be created and processed.

This link provides detailed examples for file transfer and conversion processes. The examples cover the three commonly used file formats. The formats are a sequential file with fixed length records, a sequential file with variable length records and a keyed sequential data set.

Table of Contents Previous Section Next Section Data File Compare, a User's Guide

Many companies are looking for ways to compare data files using a mainframe system and/or a distributed system (i.e. Linux, UNIX and/or Windows or "LUW") running Micro Focus sub-systems. The SimoTime Utility program (UTCOMPRT) is intended to assist in these efforts. The UTCOMPRT program runs in the Windows environment and generates comparison programs (COBOL Source Code) that may be compiled and executed on a distributed LUW platform with Micro Focus or on an IBM Mainframe.

The SimoTime Utility for Data File Compare will provide additional detail about creating a Process Control File and generating the COBOL source code for a data file compare program. The sample compare programs described in this document were generated using this utility program.

Table of Contents Previous Section Next Section Compare - Basic Function, A Simple 80/80 Compare

This link provides an example of A Simple 80/80 Compare using a generated COBOL program that compares the content of two sequential files. The package includes documentation, programs and control files.

Table of Contents Previous Section Next Section Compare - Moderate Function, Customer File with Partial Record Compare

This link provides an example of A Moderate Data Set Compare using a generated COBOL program that compares the content of two VSAM Keyed-Sequence-Data-Sets (or KSDS). The package includes documentation, programs and control files.

Table of Contents Previous Section Next Section Compare - Advanced Function, Report File Compare with Compaction and Bypass Capability

This suite of programs and documentation will describe and demonstrate additional capabilities and advanced data file compare functions for comparing report-oriented files that contain page headers with date and time stamps and user-defined line items. The ability to conditionally omit records from the compare process and to write the results of the compare process to a log file are included.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Compare Files with Variable-Length Records

This suite of programs will describe and demonstrate how to compare two record-sequential files that have variable-length records and a maximum record length of 80 bytes. The program that does the actual data file compare is a COBOL program that is generated using SimoTime technologies. The compare logic will compare the entire record for each file by using prefined positions for comparison. The results of the compare and the summary information will be posted to the SYSYOUT device.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Compare Positions Defined at Execution Time for Variable-Length Records

This suite of programs will describe and demonstrate how to compare two record-sequential files that have variable-length records and a maximum record length of 80 bytes. The program that does the actual data file compare is a COBOL program that is generated using SimoTime technologies. The compare logic will read a specifications file (SYSUT3) and compare positions within each record based on the compare statements in the specifications file. The results of the compare and the summary information will be posted to a SYSLOG file.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Compare with a Call to Convert

When data files are transferred or shared between systems the ability to do data file compares and data processing confirmation becomes a requirement. This document and the associated test cases will describe and demonstrate a minimum set of alternatives for the compare or confirm process. This suite of programs contains a test case with a call to do record conversion prior to performing the compare function.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Data File Convert, a User's Guide

Many companies are looking for ways to convert data files using a mainframe system and/or a distributed system (i.e. Linux, UNIX and/or Windows or "LUW") running Micro Focus sub-systems. The SimoTime Utility program (UTCONVRT) is intended to assist in these efforts. The UTCONVRT program runs in the Windows environment and generates conversion programs (COBOL Source Code) that may be compiled and executed on a distributed LUW platform with Micro Focus or on an IBM Mainframe.

The SimoTime Utility for Data File Convert will provide additional detail about creating a Process Control File and generating the COBOL source code for a data file convert program. The sample convert programs described in this document were generated using this utility program.

Table of Contents Previous Section Next Section Convert - Basic Function, A Simple 80/80 Convert

This link provides an example of A Simple 80/80 Convert using a generated COBOL program that compares the content of two sequential files. The package includes documentation, programs and control files.

Table of Contents Previous Section Next Section Convert - Moderate Function, Customer File Conversion with Packed and Binary Data

This link how to Convert an EBCDIC-encoded Customer Master File to ASCII using a set of generated COBOL programs that perform the conversion on a field-by-field basis. The conversion routine will retain the mainframe numeric integrity for packed and binary fields. The package includes documentation, programs and control files.

Table of Contents Previous Section Next Section Convert - Advanced Function, Convert Fixed Field to Comma Separated Values for Excel

This document and the test case will describe and demonstrate hot to read a VSAM, Key-Sequenced-Data-Set (KSDS) and create a sequential file with a record structure of Comma-Separated-Values (CSV). The fixed-length field from the VSAM, KSDS input will be converted to variable length field and the various numeric formats will be expanded to text-orientation with an explicit decimal point and a trailing sign byte.

This is actually two COBOL programs. The first program (File Format Conversion) does the File I/O for reading the Customer Master File and writing reformatted records to a sequential file. The File I/O program calls the second program to do the record content conversion (or record formatting) that expands the numeric fields and does blank truncation on the text fields and then places a comma between the fields as the field delimiter.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Convert - Miscellaneous Programs

This section describes additional Data File Conversion programs and processes that are commonly used across a variety of application groups.

Table of Contents Previous Section Next Section A Simple EBCDIC to ASCII File Content Conversion

This example uses a single COBOL program that reads an EBCDIC-encoded file of eighty (80) byte records and creates a new file of ASCII-encoded, eighty (80) byte records. The input records should contain text strings that are valid print characters.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Convert between Line & Record Sequential, EBCDIC & ASCII

This suite of sample programs will show an approach to the task of File format conversion between Line Sequential and Record Sequential files. Also, file content (or record content)conversion between ASCII and EBCDIC will be discussed. This example uses sequential files with 80-byte records.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Convert between Comma-Separated-Values and Fixed-Field-Lengths

When data is transferred or shared across a number of different systems it is often necessary to change the file format and/or the record content structure. The purpose of this suite of programs is to show an approach for preparing or converting data to be transferred or shared across systems of different architectures. This example uses sequential files with 80-byte records and ASCII/Text files.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section File Format and Record Content Conversion including Field Expansion

This suite of programs includes examples for converting record content between ASCII and EBCDIC. The document describes file format conversion between ASCII/Text and Record Sequential file formats and includes examples of repositioning and expanding field sizes and record keys for indexed files.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Data File Confirm or Verify

The data file confirmation or verification process will read a file and calculate record counts and check sum totals for user defined numeric fields.

Table of Contents Previous Section Next Section Calculate Record Counts and Summary Totals

This suite of programs and documentation will describe and demonstrate an approach for reading a file, calculating record counts and producing summary totals for a set of pre-defined numeric fields. The approach uses two COBOL programs that were generated using SimoTime technology. The programs are generated on a Windows System with Micro Focus COBOL. The generated programs may be compiled and executed on an IBM Mainframe (ZOS or VSE) or a Linux, UNIX or Windows System with Micro Focus COBOL.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Calculate Record Counts and Summary Totals for an Item Master File

This suite of programs and documentation will describe and demonstrate an approach for reading an Item Master file, calculating record counts and producing summary totals for a set of pre-defined numeric fields. The approach uses two COBOL programs that were generated using SimoTime technology. The programs are generated on a Windows System with Micro Focus COBOL. The generated programs may be compiled and executed on an IBM Mainframe (ZOS or VSE) or a Linux, UNIX or Windows System with Micro Focus COBOL.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Data File Management and Manipulation with Miscellaneous Examples

This group of documents and programs provides additional and/or creative techniques for processing files and manipulating the data within files.

Table of Contents Previous Section Next Section A File Format Conversion from Mainframe Image with Variable Length Records

The objective of this suite of programs and documentation is to provide a solution for using FTP to download a mainframe sequential file with variable length records to a system that is running Microsoft Windows and Micro Focus COBOL and convert the file format to a Micro Focus sequential file with variable length records.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section A Data File Transition Cycle with Various Convert and Compare Processes

This link provides an example of the various conversion and comparison processes that move data from EBCDIC encoded environments to ASCII encoded environments and from a Mainframe format to a format that may be easily imported into an excel spreadsheet.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Various Data File Create, Convert, Copy and Compare Examples

This link provides an example of the various create, convert, copy and compare processes that do a variety of file format conversions using IDCAMS and the REPRO function.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Data File Processing with Multiple Record Types

This link provides an example of processing a file with multiple record types using COBOL programs.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Micro Focus Environment

This section describes sample programs and documents that are unique to the Micro Focus Environment.

Table of Contents Previous Section Next Section File Formats for Micro Focus

This is a link to a white paper that provides a quick overview of the various Micro Focus File Formats provided for the Windows, Linux and UNIX environments supported by Micro Focus

Table of Contents Previous Section Next Section Micro Focus, Compiler Directives

This white paper describes the various Micro Focus compiler directives that may be required to control program behavior in the Linux, UNIX or Windows environments in a manner compliant with the compiler options and subsequent execution on the Mainframe System. The directives will affect the way programs process and format numeric fields. Once the data is stored in a data file on a permanent storage media the format of the records and their content structure must be maintained.

Table of Contents Previous Section Next Section Micro Focus, Creating & Processing Large Files (greater than 2-gig)

This program suite provides an example of how to create or access data files that exceed two gigabytes in size. Micro Focus provides support for files that exceed two gigabytes but the capability must be configured. The COBOL program is written using the COBOL/2 dialect but also work with COBOL for MVS and COBOL/370.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Micro Focus, Baseline Elapsed Timings (Small, Medium and Large Files)

This document will demonstrate and describe how to establish a set of baseline performance metrics by calculcating elapsed time for batch jobs from information extracted from the Micro Focus JES output.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Micro Focus, Dynamic File Allocation

This suite of programs and documentation will describe and demonstrate the dynamic file allocation function for the Micro Focus Studio and Server environments.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Micro Focus, Populate a Catalog

When doing an "application migration" or "transferring and sharing data" between a Mainframe System and a Windows System with Micro Focus Server it can be a challenge to create and populate the Server Catalog entries and make this a repeatable process. This document describes a possible solution to this challenge.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Micro Focus, Extract File Information from JCL

This suite of programs will scan JCL members and extract file information based on the IDCAMS specifications or DD statements. The file information will be written to a sequential file. This capability and the information it provides is quite useful when migrating a batch application and data between a Mainframe System to a Windows System using Micro Focus technologies.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section The Customer Master File

On the IBM Mainframe the Customer Master File is a VSAM Keyed Sequential Data Set (referred to as KSDS). On a Windows or UNIX System using Micro Focus the Customer Master File is an Indexed File or Key Sequenced File.

The Customer Master file contains variable length records with the minimum and average record length being the same length of 512 bytes. The key starts in the first position of the record and is 12 bytes in length. The record layout (or record structure) is defined in a COBOL copy file and contains text strings and various numeric formats including zoned-decimal, packed and binary. The COBOL copy file provides information for an application program to build a data structure in Working Storage. However, it does not provide explicit information about the start positions of fields within the records or the physical size of the various numeric formats. The HTML document provides this information.

Table of Contents Previous Section Next Section Customer Master, Create and Populate a Test File

This program suite provides an example of how to create and populate a Customer Master File. On the Mainframe System the file is a VSAM, Key-Sequenced-Data-Set (or KSDS). On a Windows or UNIX System the Micro Focus Indexed File format is used. The file contains 512 byte records and the key (or customer number) is twelve (12) bytes starting in the first position of each record.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Customer Master, Extract and Format Data for Excel

This is actually two COBOL programs. The first program does the File I/O of reading the Customer Master File and writing reformatted records to a sequential file. The File I/O program calls the second program to do the record formatting that expands the numeric fields and does blank truncation on the text fields and then places a comma between the fields as the field delimiter.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Customer Master, Convert between EBCDIC and ASCII

This is actually two COBOL programs. The first program does the File I/O of reading the Customer Master File and writing reformatted records to a sequential file. The File I/O program calls the second program to do the record formatting that expands the numeric fields and does blank truncation on the text fields and then places a comma between the fields as the field delimiter.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Customer Master, Create and Populate, Generic Name and Address

This program suite provides an example of how to create and populate a Customer Master File. The number of records in the file is determined by a parameter in a configuration file. The individual names (both first and last), the street name and the city, state are obtained from separate data files. On the Mainframe System the file is a VSAM, Key-Sequenced-Data-Set (or KSDS). On a Windows or UNIX System the Micro Focus Indexed File format is used. The file contains 512 byte records and the key (or customer number) is twelve (12) bytes starting in the first position of each record.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Customer Master, Convert from EBCDIC to ASCII

This suite of sample programs describes how to convert an EBCDIC encoded VSAM Key-Sequenced-Data-Set (KSDS) to an ASCII encoded VSAM Key-Sequenced-Data-Set (KSDS). The data set contains customer information with text, packed and binary data strings.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section The Item Master File

On the IBM Mainframe the Item Master File is a VSAM Keyed Sequential Data Set (referred to as KSDS). On a Windows or UNIX System using Micro Focus the Item Master File is an Indexed File or Key Sequenced File.

The Item (or Product) Master file contains variable length records with the minimum and average record length being the same length of 512 bytes. The key starts in the first position of the record and is 12 bytes in length. The record layout (or record structure) is defined in a COBOL copy file and contains text strings and various numeric formats including zoned-decimal, packed and binary. The COBOL copy file provides information for an application program to build a data structure in Working Storage. However, it does not provide explicit information about the start positions of fields within the records or the physical size of the various numeric formats. The HTML document provides this information.

Table of Contents Previous Section Next Section Item Master, Extract and Format Data for Excel

This is actually two COBOL programs. The first program does the File I/O of reading the Item Master File and writing reformatted records to a sequential file. The File I/O program calls the second program to do the record formatting that expands the numeric fields and does blank truncation on the text fields and then places a comma between the fields as the field delimiter.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Item Master, Convert between EBCDIC and ASCII

This is actually two COBOL programs. The first program does the File I/O of reading the Item Master File and writing reformatted records to a sequential file. The File I/O program calls the second program to do the record formatting that expands the numeric fields and does blank truncation on the text fields and then places a comma between the fields as the field delimiter.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Repository Management Programs

The repositories described in the section are VSAM, Key Sequenced Data Structures (or KSDS's). The information stored in each of the repositories can be quite useful when moving or sharing an application and data between an IBM Mainframe and a Linux, UNIX or Windows (LUW) platform running a Micro Focus Server.

Table of Contents Previous Section Next Section Repository for Application Properties

This suite of programs and documentation will provide process knowledge and technology that will collect and build a repository of information about the application source members. This includes COBOL programs and copy files, JCL and PROC's, BMS Screen Definitions and Mainframe Assembler Source Members. This example includes batch and on-line (CICS) programs. The batch is required and the on-line is optional.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Repository for File Properties

This suite of programs and documentation will provide process knowledge and technology that will collect and build a repository of information about the data files, VSAM Data Structures, Partitioned Data Sets (PDS's) and Generation Data Groups (GDG's). This example includes batch and on-line (CICS) programs. The batch is required and the on-line is optional.

Review the Documentation for this suite of program members. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.

Table of Contents Previous Section Next Section Repository for File Status Codes

The ANS/85 standard provides for a two-byte file-status-key. The first character of the file-status-key is known as status-key-1. The second character is known as status-key-2.

The combinations of possible values and their meanings are shown in the File Status Codes Documents with some comments where vendor additions or extensions may occur.

Table of Contents Previous Section Next Section Summary

The Non-Relational Data Connection provides a suite of sample programs and reference documentation for managing VSAM Data Sets or flat, sequential files (QSAM). Techniques for creating, deleting or updating are included for both VSAM and QSAM.

This document may be used as a tutorial for new programmers or as a quick reference for experienced programmers. In the world of programming there are many ways to solve a problem. This document and the links to other documents are intended to provide a choice of alternatives.

Table of Contents Previous Section Next Section Software Agreement and Disclaimer

Permission to use, copy, modify and distribute this software, documentation or training material for any purpose requires a fee to be paid to SimoTime Enterprises. Once the fee is received by SimoTime the latest version of the software, documentation or training material will be delivered and a license will be granted for use within an enterprise, provided the SimoTime copyright notice appear on all copies of the software. The SimoTime name or Logo may not be used in any advertising or publicity pertaining to the use of the software without the written permission of SimoTime Enterprises.

SimoTime Enterprises makes no warranty or representations about the suitability of the software, documentation or learning material for any purpose. It is provided "AS IS" without any expressed or implied warranty, including the implied warranties of merchantability, fitness for a particular purpose and non-infringement. SimoTime Enterprises shall not be liable for any direct, indirect, special or consequential damages resulting from the loss of use, data or projects, whether in an action of contract or tort, arising out of or in connection with the use or performance of this software, documentation or training material.

Table of Contents Previous Section Next Section Downloads and Links to Similar Pages

This section includes links to documents with additional information that are beyond the scope and purpose of this document.

Note: The latest versions of the SimoTime Documents and Program Suites are available on the Internet and may be accessed using the Link to Internet icon. If a user has a SimoTime Enterprise License the Documents and Program Suites may be available on a local server and accessed using the Link to Server icon.

Link to Internet   Link to Server   Explore the Assembler Connection for more examples of mainframe Assembler programming techniques and sample code.

Link to Internet   Link to Server   Explore the COBOL Connection for more examples of COBOL programming techniques and sample code.

Link to Internet   Link to Server   Explore the JCL Connection for more examples of JCL functionality with programming techniques and sample code.

Link to Internet   Link to Server   Explore the Numbers Connection for additional information about the structure and processing of numeric data items (or numeric fields).

Link to Internet   Link to Server   Explore the SQL Connection for more examples of how to create, manipulate and delete Relational Data Bases. The COBOL programs are written to compile and execute on a Windows System with SQL Server and Micro Focus Enterprise Server or an IBM Mainframe System with DB2.

Link to Internet   Link to Server   Explore An Enterprise System Model that describes and demonstrates how Applications that were running on a Mainframe System and non-relational data that was located on the Mainframe System were copied and deployed in a Microsoft Windows environment with Micro Focus Enterprise Server.

Link to Internet   Link to Server   Explore an Extended List of Software Technologies that are available for review and evaluation. The software technologies (or Z-Packs) provide individual programming examples, documentation and test data files in a single package. The Z-Packs are usually in zip format to reduce the amount of time to download.

Link to Internet   Link to Server   Explore The ASCII and EBCDIC Translation Tables. These tables are provided for individuals that need to better understand the bit structures and differences of the encoding formats.

Link to Internet   Link to Server   Explore The File Status Return Codes to interpret the results of accessing VSAM data sets and/or QSAM files.

Table of Contents Previous Section Next Section Downloads and Links, Internet Access Required

The following links will require an internet connect.

A good place to start is The SimoTime Home Page via Internet Connect for access to white papers, program examples and product information.

Explore The Micro Focus Web Site via Internet Connect for more information about products and services available from Micro Focus.

Table of Contents Previous Section Next Section Glossary of Terms

Link to Internet   Link to Server   Explore the Glossary of Terms for a list of terms and definitions used in this suite of documents and white papers.

Table of Contents Previous Section Next Section Comments, Suggestions or Feedback

This document was created and is copyrighted and maintained by SimoTime Enterprises.

If you have any questions, suggestions, comments or feedback please call or send an e-mail to: helpdesk@simotime.com

We appreciate hearing from you.

Table of Contents Previous Section Next Section Company Overview

Founded in 1987, SimoTime Enterprises is a privately owned company. We specialize in the creation and deployment of business applications using new or existing technologies and services. We have a team of individuals that understand the broad range of technologies being used in today's environments. This includes the smallest thin client using the Internet and the very large mainframe systems. There is more to making the Internet work for your company's business than just having a nice looking WEB site. It is about combining the latest technologies and existing technologies with practical business experience. It's about the business of doing business and looking good in the process. 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.

Whether you want to use the Internet to expand into new market segments or as a delivery vehicle for existing business functions simply give us a call or check the web site at http://www.simotime.com


Return-to-Top
Non-Relational Data Connection, File Accessing Methods, Utility Programs and SORT
Copyright © 1987-2013 SimoTime Enterprises  All Rights Reserved
When technology complements business
http://www.simotime.com