Sequential File with Packed-Decimal
|
Totals & Record Counts Sequential File with Packed-Decimal |
|
| The SimoTime Home Page |
Introduction
The SimoTime Technologies have the capability of generating a COBOL program that will read a Data File or VSAM Data Set and calculate a record count and accumulate summary totals for the user-defined, numeric fields within a record. This suite of programs will focus on processing numeric fields that are defined as Packed Decimal. Once the record count and summary totals are accumulated they are written to a user-defined output device that may be a file or a SYSOUT device.
The execution of this suite of programs is the 2nd task within a group of three (3) tasks.
Explore how to Create Test Data Files. For this suite of jobs and programs the file format will be record sequential and the record format will be a fixed-length of 80-byte records containing text strings and packed-decimal numeric fields.
Explore how to Calculate a Record Count and Accumulate Summary Totals by reading a Record Sequential Data File. Each record contains numeric fields with a packed-decimal (COMP-3) format. The count and totals will be posted to the SYSOUT device.
Explore how to Validate the Content of Two Data Files by doing a record-by-record compare of two sequential files with 121-byte records. The COBOL source code for the program was generated using SimoTime technologies. This suite of programs was originally inteneded to compare two SYSOUT files since a SYSOUT device is typically configured as a record sequential file with 121-byte records.
This suite of programs is used by SimoTime as a regression test for processing (i.e. accumulating summary totals) numeric information that is stored in a Packed-Decimal (COMP-3) format. The primary objective is to create the summary totals for each of the numeric fields. The secondary objective is to validate the content each of the numeric fields.
Note: One of the challenges of using the Packed-Decimal format is the possibility of a field containing a non-numeric value. If this happens the program processing the field must be able to recognize the condition and execute alternate processing to avoid a system error and subsequent abnormal termination of the program.
The "Execute" section of this document will describe and demonstrate how to run a job that will read a file and post the summary totals to a SYSOUT file. The "Prepare" section of this document will describe and demonstrate how to generate the programs that will accumulate summary totals and record counts.
We have made a significant effort to ensure the documents and software technologies are correct and accurate. We reserve the right to make changes without notice at any time. The function delivered in this version is based upon the enhancement requests from a specific group of users. The intent is to provide changes as the need arises and in a timeframe that is dependent upon the availability of resources.
Copyright © 1987-2025
SimoTime Technologies and Services
All Rights Reserved
Execute
This section will describe and demonstrate how to run a job that will read a file and post the summary totals to a SYSOUT file.
Diagram of Logic and Data Flow
The following shows the logic and data flow for the job that accumulates summary totals and record counts.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Note-1: SYSUT1 identifies an ASCII/Text or Line Sequential (LSEQ) file containing summary totals and record counts. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Note-2: Within the SYSUT1 records the Packed-Decimal format is used for the numeric fields. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Note-3: SYSOUT is configured to be an ASCII/Text file with a maximum record length of 121 bytes. |
| Accumulate Summary Totals and Record Counts |
Set Environment & Execute 1st Job
The following Windows Command File (PKTOTSW1.cmd) will set the environment and execute the program that accumulates the summary totals and record counts for the 1st data file.
@echo OFF
rem * *******************************************************************
rem * PKTOTSW1.cmd - a Windows Command File *
rem * This program is provided by SimoTime Technologies *
rem * (C) Copyright 1987-2019 All Rights Reserved *
rem * Web Site URL: http://www.simotime.com *
rem * e-mail: helpdesk@simotime.com *
rem * *******************************************************************
rem *
rem * Text - Read a file, Calculate record count and numeric totals.
rem * Author - SimoTime Technologies
rem * Date - January 24, 1988
rem *
rem * The job will read a record sequential file of 80-byte records that
rem * contains numeric fields within the records.
rem * The programs will read the file and calculate summary totals for
rem * user-defined numeric fields and a record count for the file.
rem * The information will then be posted to the SYSOUT device.
rem *
rem * ************
rem * * PKTOTSW1 *
rem * ********cmd*
rem * *
rem * *
rem * ************ ************ ************
rem * * SYSUT1 ******* PKTOTSV1 ******* SYSOUT *
rem * *******rseq* ********cbl* *******lseq*
rem * *
rem * *
rem * ************
rem * * EOJ *
rem * ************
rem *
rem * Note: PKTOTSV1 calls PKTOTSR1
rem *
rem * This set of programs will run on a Windows System with Micro Focus
rem * Enterprise Developer.
rem *
rem * *******************************************************************
rem * Read a File, Calculate Record Counts and Summary Totals...
rem *
set CmdName=PKTOTSW1
call ..\Env1BASE %CmdName%
if "%SYSLOG%" == "" set syslog=c:\SimoLIBR\LOGS\SimoTime.LOG
rem *
call SimoNOTE "*******************************************************%CmdName%"
call SimoNOTE "Starting CmdName %CmdName%"
rem *
rem * *******************************************************************
call SimoNOTE "StepInfo Prepare the environment"
set SYSUT1=%BaseLib1%\DATA\ASC1\SIMOTIME.RSEQ.PKTOTSD1.DAT
set SYSOUT=%BaseLib1%\LOGS\SYSOUT_%CmdName%.TXT
if exist %SYSOUT% erase %SYSOUT%
rem *
rem * *******************************************************************
call SimoNOTE "StepInfo Execute the Program to Calculate Totals"
call SimoNOTE "DataTake %SYSUT1%"
call SimoNOTE "DataMake %SYSOUT%"
run PKTOTSV1
if not "%ERRORLEVEL%" == "0" set JobStatus=0010
if not %JobStatus% == 0000 goto :EojNok
if exist %SYSOUT% type %SYSOUT%
goto :EojAok
rem *
rem * *******************************************************************
:EojAok
call SimoNOTE "Finished JobName %CmdName%, Job Status is %JobStatus%"
goto :End
:EojNok
call SimoNOTE "ABENDING JobName %CmdName%, Job Status is %JobStatus%"
:End
if not "%1" == "nopause" pause
Set Environment & Execute 2nd Job
The following Windows Command File (PKTOTSW2.cmd) will set the environment and execute the program that accumulates the summary totals and record counts for the 2nd data file.
@echo OFF
rem * *******************************************************************
rem * PKTOTSW2.cmd - a Windows Command File *
rem * This program is provided by SimoTime Technologies *
rem * (C) Copyright 1987-2019 All Rights Reserved *
rem * Web Site URL: http://www.simotime.com *
rem * e-mail: helpdesk@simotime.com *
rem * *******************************************************************
rem *
rem * Text - Read a file, Calculate record count and numeric totals.
rem * Author - SimoTime Technologies
rem * Date - January 24, 1988
rem *
rem * The job will read a record sequential file of 80-byte records that
rem * contains numeric fields within the records.
rem * The programs will read the file and calculate summary totals for
rem * user-defined numeric fields and a record count for the file.
rem * The information will then be posted to the SYSOUT device.
rem *
rem * ************
rem * * PKTOTSW2 *
rem * ********cmd*
rem * *
rem * *
rem * ************ ************ ************
rem * * SYSUT1 ******* PKTOTSV1 ******* SYSOUT *
rem * *******rseq* ********cbl* *******lseq*
rem * *
rem * *
rem * ************
rem * * EOJ *
rem * ************
rem *
rem * Note: PKTOTSV1 calls PKTOTSR1
rem *
rem * This set of programs will run on a Windows System with Micro Focus
rem * Enterprise Developer.
rem *
rem * *******************************************************************
rem * Read a File, Calculate Record Counts and Summary Totals...
rem *
set CmdName=PKTOTSW2
call ..\Env1BASE %CmdName%
if "%SYSLOG%" == "" set syslog=c:\SimoLIBR\LOGS\SimoTime.LOG
rem *
call SimoNOTE "*******************************************************%CmdName%"
call SimoNOTE "Starting CmdName %CmdName%"
rem *
rem * *******************************************************************
call SimoNOTE "StepInfo Prepare the environment"
set SYSUT1=%BaseLib1%\DATA\ASC1\SIMOTIME.RSEQ.PKTOTSD2.DAT
set SYSOUT=%BaseLib1%\LOGS\SYSOUT_%CmdName%.TXT
if exist %SYSOUT% erase %SYSOUT%
rem *
rem * *******************************************************************
call SimoNOTE "StepInfo Execute the Program to Calculate Totals"
call SimoNOTE "DataTake %SYSUT1%"
call SimoNOTE "DataMake %SYSOUT%"
run PKTOTSV1
if not "%ERRORLEVEL%" == "0" set JobStatus=0010
if not %JobStatus% == 0000 goto :EojNok
if exist %SYSOUT% type %SYSOUT%
goto :EojAok
rem *
rem * *******************************************************************
:EojAok
call SimoNOTE "Finished JobName %CmdName%, Job Status is %JobStatus%"
goto :End
:EojNok
call SimoNOTE "ABENDING JobName %CmdName%, Job Status is %JobStatus%"
:End
if not "%1" == "nopause" pause
Review the Results
This section shows the content of the two SYSOUT files. In the 1st Job the field name "PKTOTS01-VALUE-03" contains a value of 570. In the 2nd job the same field contains a value of 572.
This difference will be programmatically identified by the compare process that is executed as part of the 3rd task within this group of three (3) tasks.
Summary Totals for 1st Job
The following is an example of the output produced by the 1st job. This example shows the summary totals for the user-defined field and the record count for the test file.
* PKTOTSV1 Accumulate Packed Decimal Fields v15.05.18 helpdesk@simotime.com * PKTOTSV1 A Program to Calculate Totals was generated by SimoTime Technologies * PKTOTSV1 * HEX20 parameter is DISABLE * PKTOTSV1 * HEX40 parameter is DISABLE * PKTOTSV1 * HEXTR parameter is DISABLE * PKTOTSV1 * NUMCHK parameter is ENABLE * PKTOTSV1 ************************************************************************************************************ * PKTOTSV1 Field Name Summary.Total HEX40 HEX20 NUMCHK TYPE * PKTOTSV1 PKTOTS01-VALUE-01 1,235,802,647.09 PK * PKTOTSV1 PKTOTS01-VALUE-02 1,416.660 PK * PKTOTSV1 PKTOTS01-VALUE-03 570 PK * PKTOTSV1 Record count for SYSUT1 000000008 * PKTOTSV1 Field Name Summary.Total HEX40 HEX20 NUMCHK TYPE * PKTOTSV1 ************************************************************************************************************ * PKTOTSV1 Program to Calculate Totals generated by using SimoTime Technologies * PKTOTSV1 Please send all comments or suggestions to the helpdesk@simotime.com
Summary Totals for 2nd Job
The following is an example of the output produced by the 2nd job. This example shows the summary totals for the user-defined field and the record count for the test file.
* NBRPK3C2 Packed Numeric Field with SPACES v15.05.18 helpdesk@simotime.com * NBRPK3C2 A Program to Calculate Totals was generated by SimoTime Technologies * NBRPK3C2 * HEX20 parameter is ZERO_ADJ * NBRPK3C2 * HEX40 parameter is ZERO_ADJ * NBRPK3C2 * HEXTR parameter is DISABLE * NBRPK3C2 * NUMCHK parameter is DISABLE * NBRPK3C2 ************************************************************************************************************ * NBRPK3C2 Field Name Summary.Total HEX40 HEX20 NUMCHK TYPE * NBRPK3C2 NBRPK3B1-FIELD-01 123 0000002 PK * NBRPK3C2 NBRPK3B1-FIELD-02 1,368- PK * NBRPK3C2 NBRPK3B1-FIELD-03 1,230 0000001 PK * NBRPK3C2 NBRPK3B1-FIELD-04 199,998 0000001 PK * NBRPK3C2 Record count for SYSUT1 000000003 * NBRPK3C2 Field Name Summary.Total HEX40 HEX20 NUMCHK TYPE * NBRPK3C2 ************************************************************************************************************ * NBRPK3C2 Program to Calculate Totals generated by using SimoTime Technologies * NBRPK3C2 Please send all comments or suggestions to the helpdesk@simotime.com
Prepare
Before the jobs can be executed some preparation work will be required. The validation programs (summary totals and record count) need to be generated. Test data will need to be created. The environment will need to be configured. The programs will need to be compiled and the executable members will need to be promoted to the load library.
Prepare Programs for Totals
This section will describe the Process Control File and how it is used to generate and compile the programs that will do the file read and accumulation of summary totals with a record count.
The Process Control File
The following Process Control File (PKTOTSV1.pcf) is used to generate the program that accumulate the summary totals and record counts.
*********************************************************************** * PKTOTSV1.pcf - a Process Control File * * SimoTime Program Generation Technologies * * (C) Copyright 1987-2019 All Rights Reserved * * Web Site URL: http://www.simotime.com * * e-mail: helpdesk@simotime.com * *********************************************************************** * SYSUT1 is the Sequential File with 80-byte records. *********************************************************************** * This Process Control File will be used to generate a set of COBOL * programs that will accumulate totals for user-defined numeric fields * and provide a record count. * * Refer to http://www.simotime.com/utcomp01.htm for additional detail * about the PCF statements for Data Validate, Dump and Compare. * * The following group of statements will define the high level * functions and processes to be performed. * &SIMOPREP call ..\ENV1BASE &USERPREP call USERCOGI &CONFORM IBM ©FILE PKTOTSB1.cpy &HTMLFILE pktotsb1.htm * * The following group of statements will define the behavioral * characteristics and environment variable for the file I/O Program * to be generated. * *HEAD34 ....:....1....:....2....:....3.... &HEAD34 Accumulate Packed Decimal Fields &PROGID PKTOTSV1 &SYSUT1 org=Sequential recfm=FIXED rlen=80 * * The following group of statements will define the behavioral * characteristics and environment variables for the record content * conversion program to be generated. * The following defines the name of the callable routine for special * numeric processing. * &NUMCALL PKTOTSR1 &NUMREC PKTOTSD1-RECORD * * The following group of statements will look at the user-defined * numeric fields and compensate when the field contains all space * characters or non-numeric values. * &HEX40 DISABLE &HEX20 DISABLE &HEXTR ENABLE &NUMCHK ENABLE * * The following group of statements will define the type of processing * and the name of the numeric fields. * &UT1TOTAL PKTOTS01-VALUE-01 &UT1TOTAL PKTOTS01-VALUE-02 &UT1TOTAL PKTOTS01-VALUE-03 * &END
Generate the Programs
The SimoTime Technologies are used to generate the COBOL programs that will actually read a file and produce a report that contains summary totals for user-defined fields and a record count for the number of records in the file.
Explore How to Generate a Data File Compare, Validate or Hex-Dump Program using simple specification statements in a Process Control File (PCF). This link to the User Guide includes the information necessary to create a Process Control File and generate the COBOL programs that will do a data file compare, accumulate summary totals with a record count or produce a Hex-Dump of records in a VSAM, KSDS based on a list of user-defined keys. The User Guide contains a list of the PCF statements that are used for the data file compare, validate or dump process.
Compile the Programs
For the Micro Focus environment the programs are compiled using the following compiler directives.
DIALECT"ENTCOBOL" CHARSET"ASCII" ASSIGN"EXTERNAL" IDXFORMAT"8" IBMCOMP NOTRUNC HOSTNUMMOVE HOSTNUMCOMPARE NOSIGNFIXUP HOSTARITHMETIC NOHOSTFD CHECKNUM ANIM COBIDY NOOPTIONAL-FILE outdd"SYSOUT 121 L" SHARE-OUTDD DATE TIME DATAMAP settings list() noform
The following links will provide additional information about the Micro Focus compiler directives.
Explore the Compiler Directives available for the Micro Focus COBOL technologies.
Technical Details
This section provides additional details about the programs and control files that are used in this suite of programs.
Record Structure for Test File
The file format for the test file is record sequential with a fixed record length of eighty (80) bytes. The record content has one text string and three (3) numeric fields that are defined as packed-decimal (or COMP-3) format.
COBOL Copy File for Test File
The following source member (PKTOTSB1.cpy) is the COBOL Copy File that defines the record structure for the test file.
*****************************************************************
* PKTOTSB1.CPY - a COBOL Copy File *
* A Record Structure Containing Numeric Fields *
* Used for Calculating and Testing CheckSum Totals *
* Copyright (C) 1987-2019 SimoTime Technologies *
* All Rights Reserved *
* Provided by SimoTime Technologies *
* Our e-mail address is: helpdesk@simotime.com *
* Also, visit our Web Site at http://www.simotime.com *
*****************************************************************
*
01 PKTOTSD1-RECORD. 01-80
05 PKTOTS01-ALPHA-01 PIC X(32). 01-32
05 FILLER PIC X. 33-33
05 PKTOTS01-VALUE-01 PIC 9(10)V99 COMP-3. 34-40
05 FILLER PIC X. 41-41
05 PKTOTS01-VALUE-02 PIC 9(8)V999 COMP-3. 42-47
05 FILLER PIC X. 48-48
05 PKTOTS01-VALUE-03 PIC S9(5) COMP-3. 49-51
05 FILLER PIC X. 52-52
05 FILLER PIC X(28). 53-80
*
*** PKTOTSB1 - End-of-Copy File - - - - - - - - - - - PKTOTSB1 *
*****************************************************************
*
HTML Document for Test File
The SimoTime Technologies have the ability to scan a COBOL copy file and create an HTML document of a record structure or record layout. The HTML documentation provides information that is not easy to obtain by viewing the COBOL copy file. For example, the physical position of a field within a record as calculated during the copy file scan and placed in the HTML document.
Explore an HTML document that describes the Record Structure of the Test File used by the job that accumulates Summary Totals and calculates a record count. The numeric fields are packed-decimal (or COMP-3) format. The record structure and generated HTML document for this file are based on a User-Supplied COBOL copyfile.
Summary
The SimoTime Technologies have the capability of generating a COBOL program that will read a Data File or VSAM Data Set and calculate a record count and accumulate summary totals for the user-defined, numeric fields within a record. This suite of programs will focus on processing numeric fields that are defined as Packed Decimal. This document may be used to assist as a tutorial for new programmers or as a quick reference for experienced programmers that are interested in improving their testing process by leveraging additional functionality and data validation techniques.
In the world of programming there are many ways to solve a problem. This documentation and software were developed and tested on systems that are configured for a SIMOTIME environment based on the hardware, operating systems, user requirements and security requirements. Therefore, adjustments may be needed to execute the jobs and programs when transferred to a system of a different architecture or configuration.
SIMOTIME Services has experience in moving or sharing data or application processing across a variety of systems. For additional information about SIMOTIME Services or Technologies please contact us using the information in the Contact or Feedback section of this document.
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 Technologies. 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 Technologies.
SimoTime Technologies 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 Technologies 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.
Downloads and Links
This section includes links to documents with additional information that are beyond the scope and purpose of this document. The first group of documents may be available from a local system or via an internet connection, the second group of documents will require an internet connection.
Note: A SimoTime License is required for the items to be made available on a local system or server.
Current Server or Internet Access
The following links may be to the current server or to the Internet.
Note: The latest versions of the SimoTime Documents and Program Suites are available on the Internet and may be accessed using the 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 icon.
Explore The Packed-Decimal or COMP-3 format for numeric data strings. This numeric structure is supported by COBOL and may be explicitly defined with the "USAGE IS COMP-3" clause.
Explore how to process non-Numeric Values stored in a Packed-Decimal format. This document will use examples to show how to manage a situation where non-numeric values (such as Space Characters) are placed in a Packed-Decimal field and then managed to avoid a S0C7 or RTS 163 error message and an abnormal termination of the program.
Explore the Numbers Connection for additional information about the structure and processing of numeric data items (or numeric fields).
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.
Explore the COBOL Connection for more examples of COBOL programming techniques and sample code.
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.
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.
Explore The File Status Return Codes that are used to interpret the results of accessing VSAM data sets and/or QSAM files.
Internet Access Required
The following links will require an internet connection.
This suite of programs and documentation is available for download. Link to an Evaluation zPAK Option that includes the program members, documentation and control files.
A good place to start is The SimoTime Home Page for access to white papers, program examples and product information. This link requires an Internet Connection
Explore The Micro Focus Web Site for more information about products (including Micro Focus COBOL) and services available from Micro Focus. This link requires an Internet Connection.
Glossary of Terms
Explore the Glossary of Terms for a list of terms and definitions used in this suite of documents and white papers.
Contact or Feedback
This document was created and is maintained by SimoTime Technologies. If you have any questions, suggestions, comments or feedback please use the following contact information.
| 1. | Send an e-mail to our helpdesk. |
| 1.1. | helpdesk@simotime.com. |
| 2. | Our telephone numbers are as follows. |
| 2.1. | 1 415 763-9430 office-helpdesk |
| 2.2. | 1 415 827-7045 mobile |
We appreciate hearing from you.
Company Overview
SimoTime Technologies was founded in 1987 and 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. Our customers include small businesses using Internet technologies to corporations using very large mainframe systems.
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.
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 |
| Summary Totals and Record Counts for Packed Decimal |
| Copyright © 1987-2025 SimoTime Technologies and Services All Rights Reserved |
| When technology complements business |
| http://www.simotime.com |