MC T112 File Conversion T112 EBCDIC-encoded to ASCII/Text

Introduction

Interpreting the Integrated Product Messages (IPM) within the MC T112 File on a Linux, UNIX or Windows System presents a number of technical challenges. Typically, the file is received using FTP in BINARY Mode. The record structure is variable length and the record content is EBCDIC encoded and includes bit-sensitive and Binary data elements. Next, the data elements within the variable length record may be variable length. A data element may be "included in" or "omitted from" the record content based on the Primary or Secondary Bit Map elements included at the beginning of a record.

IPM messages are based on the variable-length specifications of the International Organization for Standardization (ISO) 8583-1993 Financial Transaction Card Originated Messages - Interchange Message Specifications. Because the clearing system with IPM is offline, it supports only non-interactive IPM messages (Notification/1x4x). ISO defines Notification/1x4x with a 4 in the third position in the Message Type Identifier (MTI).

The SIMOTIME T112 Conversion Utility Program will convert the EBCDIC -encoded, Master Card or MC T112 file to an ASCII/Text file with the bit-sensitive information expanded to text strings. The T112 file is a clearing file for financial transactions and may be used during the reconciliation process. The record structure uses an Integrated Product Messages (IPM) format with variable-length records. It is based on the ISO 8583-1993 specification.

Additional information about this program may be obtained by sending an e-mail to: helpdesk@simotime.com

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-2024
SimoTime Technologies and Services
All Rights Reserved

Program Overview

This section provides the information that is needed to understand, configure and run the T112 File Conversion job.

Job Diagram

The following shows the executable members and data structures used within the T112 File Conversion Job.

Color Associations: The  light-green  boxes are unique to SIMOTIME Technologies using an IBM Mainframe System or Micro Focus Enterprise Developer. The  light-red  boxes are unique to the SIMOTIME Technologies using a Linux, UNIX or Windows System and COBOL Technologies such as Micro Focus. The  light-yellow  boxes are SIMOTIME Technologies, Third-party Technologies, decision points or program transitions in the processing logic or program generations. The  light-blue  boxes identify the input/output data structures such as Documents, Spreadsheets, Data Files, VSAM Data Sets, Partitioned Data Set Members (PDSM's) or Relational Tables. The  light-gray  boxes identify a system function or an informational item.

Program Functionality

The following describes the functionality provided by the T112 File Conversion Utility.

The T112 Conversion Program reads the EBCDIC encoded file with variable-length records and writes to an ASCII/Text File. The original input file remains unchanged.

The System Environment

The following describes a System Environment that is required to run the T112 File Conversion Utility Program.

The primary development and testing environment at SIMOTIME is a Windows/7 System running Java JDK 8.

The CMD Member

The following is the Windows Command file (JVT112W1.cmd) that is required to run as a job on a Windows System.

@echo OFF
     set JobName=JVT112W1
rem  * *******************************************************************
rem  *               JVT112W1.cmd - a Windows Command File               *
rem  *       This Job Script 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   - File and Record Format Conversion for T112 File.
rem  * Author - SimoTime Technologies
rem  * Date   - December 15, 2016
rem  *
rem  * *******************************************************************
rem  * Step 1, Prepare the System Environment...
rem  *
     call ..\ENV1BASE %CmdName%
     if "%SYSLOG%" == "" set syslog=c:\SimoLIBR\LOGS\SimoTime.LOG
     set JobStatus=0000
rem  *
     call SimoNOTE "*******************************************************%JobName%"
     call SimoNOTE "Starting JobName %CmdName%"
     call SimoNOTE "CATALINA_HOME ... %CATALINA_HOME%"
     call SimoNOTE "JRE_HOME ........ %JRE_HOME%"
     call SimoNOTE "CLASSPATH ....... %CLASSPATH%"
rem  *
rem  *            12345678/12345678
     set PGMFLAGS=NNNNNNNN/NNYYNNNN
     set FLDDELIM=,
     set EDITCHAR=*
     set EDITMASK=0000000000001111
rem  *
     set SYS1BSIO=C:\AC2017\MM02\DEVL\DATA\Ebc1\IPM_IN_314_E01_31401.dat
     set SYS1LCSV=%BASELIB1%\DATA\WRK2\SIMOTIME.T112W1.SYS1LCSV.csv
     set SYS1MSGS=%BASELIB1%\LOGS\SIMOTIME.T112.SYS1MSGS.txt
     set XBYT00FF=%BASELIB1%\DATA\WRK2\SIMOTIME.ARRAY.XBYT00FF.dat
     set XE2ACONV=%BASELIB1%\DATA\WRK2\SIMOTIME.ARRAY.XASC9437.dat
rem  *
     if  exist %SYS1LCSV% erase %SYS1LCSV%
     if  exist %SYS1MSGS% erase %SYS1MSGS%
rem  *
rem  * *******************************************************************
rem  * Step 2, Execute the Java Program...
     call SimoNOTE "Continue JobName%JobName% Read from SYS1BSIO and write to SYS1LCSV"
     java simpacks/jvt112e1
     if not ERRORLEVEL = 0 set JobStatus=0010
     if not %JobStatus% == 0000 goto :EojNok
rem  *
rem  * *******************************************************************
rem  * Step 3, End-of-Job Processing...
:EojAok
     call SimoNOTE "Finished JobName %JobName%, Job Status is %JobStatus%"
     goto :End
:EojNok
     call SimoNOTE "ABENDING JobName %JobName%, Job Status is %JobStatus%"
:End
     if not "%1" == "nopause" pause

Technical Details

This section provides technical information about the components required or referenced in this suite of programs.

Environment Variables

The T112 Conversion Program uses the following environment variables to alter program behavior.

Program Flags, PGMFLAGS

The PGMFLAGS environment variable is used to define a set of program flags that will be used to control program behavior and trace functions. The first set of eight (8) flags is used for program behavior. The second set of eight (8) flags is used to enable trace functions. The two (2) sets of flags are separated by a "/" character.

C:\SIMOSAM1\DEVL\LOADLIB>set PGMFLAGS=NNNNNNNN/NNYYNNNN

The preceding "set" statement will cause the T112 Conversion Program to write trace information to the SYS1MSGS file.

Field Delimiter Character, FLDDELIM

The T112 Conversion program accesses an EBCDIC-encoded, Record Sequential file that was transferred from an IBM Mainframe to a Windows System using FTP in BINARY mode.

A new ASCII-encoded, Line Sequential file is created. The record structure uses a Comma-Separated-Values (CSV) format.

The FLDDELIM environment variable is used to define a character to be used as the field delimiter.

C:\SIMOSAM1\DEVL\LOADLIB>set FLDDELIM=,

The preceding "set" statement will cause the T112 Conversion Program to use the comma symbol "," as a field delimiter.

Credit Card Masking, EDITCHAR & EDITMASK

The T112 Conversion program has the capability of masking a credit card number based on two (2) environment variables. The EDITCHAR environment variable specifies the masking character to be used. The EDITMASK environment variable defines the positions within the credit card text string that will be masked or shared.

C:\SIMOSAM1\DEVL\LOADLIB>set EDITCHAR=*
C:\SIMOSAM1\DEVL\LOADLIB>set EDITMASK=0000000000001111

The preceding pair of "set" statements will cause the T112 Conversion Program to cause a credit card number of 1111222233331234 to be converted to ************1234. Only the last four (4) digits of the credit card number will be shared.

Ancillary Functions

This suite of programs references other system and user members in order to function in a larger environment that includes other languages and sub-systems. The following link provides additional details.

    Explore How to use Common or Shared Routines that perform repetitive tasks in a consistent manner. This link will provide information about setting common environment variables and many other utilitarian tasks.

Summary

The SIMOTIME T112 Conversion Utility Program will convert the EBCDIC encoded, T112 file to an ASCII/Text file with the bit-sensitive information expanded to text strings. The T112 file is a clearing file for financial transactions. The record structure uses an Integrated Product Messages (IPM) format with variable-length records. It is based on the ISO 8583-1993 specification. This document may be used to assist as a tutorial for new users or as a quick reference for experienced users.

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 Java Connection for examples of the various coding or programming techniques using the Java Software Development Kit from Oracle/Sun.

    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 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.

Internet Access Required

The following links will require an Internet connection.

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 Java Development and Run Time products and services available from Oracle. This link requires an Internet Connection.

Explore the GnuCOBOL Technologies available from SourceForge. SourceForge is an Open Source community resource dedicated to helping open source projects be as successful as possible. GnuCOBOL (formerly OpenCOBOL) is a COBOL compiler with run time support. The compiler (cobc) translates COBOL source to executable using intermediate C, designated C compiler and linker. This link will require an Internet Connection.

Explore the System/76 Web Site for more information about the products and services available from System/76. Their web site includes a description of the hardweare (laptops, desktops and servers) and the Linux Operating Systems (Ubuntu and Pop!). 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.

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