MC T112 File Conversion
T112 EBCDIC-encoded to ASCII/Text
  Table of Contents  v-18.09.15 - jvt11201.htm 
  Introduction
  Program Overview
  Job Diagram
  Program Functionality
  The System Environment
  The CMD Member
  Technical Details
  Environment Variables
  Program Flags, PGMFLAGS
  Field Delimiter Character, FLDDELIM
  Credit Card Masking, EDITCHAR & EDITMASK
  Ancillary Functions
  Summary
  Software Agreement and Disclaimer
  Downloads and Links
  Current Server or Internet Access
  Internet Access Required
  Glossary of Terms
  Comments or Feedback
  Company Overview
The SimoTime Home Page 

Table of Contents Previous Section Next Section 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-2019
SimoTime Technologies and Services
All Rights Reserved

Table of Contents Previous Section Next Section Program Overview

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

Table of Contents Previous Section Next Section Job Diagram

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

             
JVT112W1
cmd
Start the Job, Convert the T112 File
from EBCDIC/ZOS-variable to ASCII/Text
   
SYS1BSIO
ZOS
Variable
   
   
jvt112e1
java
   
   
SYS1LCSV
LSEQ
Comma-Separated
Read ZOS file and create a comma-delimited file
   
   
   
XE2ACONV
RSEQ
Fixed-256
   
   
   
   
   
SYS1MSGS
LSEQ
ASCII/Text
Input is Record Sequential, Output is ASCII/Text
   
   
XBYT00FF
RSEQ
Fixed-256
   
   
   
Record Sequential, 256-byte, Binary array
   
   
PGMFLAGS
   
   
   
Define Program Behavior Flags
   
   
FLDDELIM
   
   
   
Define the Field Delimiter Character
   
   
EDITCHAR
EDITMASK
   
   
   
Define the Data Masking for the PAN, DE 2
   
EOJ
This is End-of-Job.
 
Note-1: The following notations are used for file formats.
LSEQ = Line Sequential or ASCII/Text File
RSEQ = Record Sequential File
ZOS = IBM Mainframe System
Create an ASCII/Text (LSEQ) Comma Delimited file from a ZOS, EBCDIC-encoded, Sequential file of variable-length records

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.

Table of Contents Previous Section Next Section Program Functionality

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

1. The File Conversion Utility will read the EBCDIC encoded file with bit-mapped records and write to an ASCII/Text file with field-delimited records.
1.1. The field delimiter character is configurable. The default value is a comma character.
1.2. The File Conversion Utility provides a character masking technique for the Primary Account Number (PAN or DE 2).
1.3. Replace DE 55, Integrated Circuit Card (ICC) System-Related Data with one space character.
Note: This Data Element contains binary information that cannot be stored in an ASCII/Text File.
1.4. Program File Names may be externally mapped to physical file names (i.e. File location and name).
1.5. The ASCII translation table may be user-defined.

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.

Table of Contents Previous Section Next Section The System Environment

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

1. Create a System that has the prerequisite software for running the Conversion Utility Program.
1.1. A Windows System is required.
1.1.1. Windows/7 and Windows/10 are used for the development and testing of the conversion jobs and programs.
1.1.2. For a single-use production environment Windows/7 or later is required.
1.1.3. For a multi-user Server environment Microsoft Server 2012 or later is required.
1.2. A Java Runtime Environment (JRE) is required.
1.2.1. The Java Developer?s Kit (JDK) 8 is used for the development and testing of the conversion jobs and programs.
1.2.2. For the production environment JDK 8 or JRE 8 is required.

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

Table of Contents Previous Section Next Section 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

Table of Contents Previous Section Next Section Technical Details

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

Table of Contents Previous Section Next Section Environment Variables

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

1. PGMFLAGS=NNNNNNNN/NNNNNNNN
2. FLDDELIM=,
3. EDITCHAR=*
4. EDITMASK=1111111111111111

Table of Contents Previous Section Next Section 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.

Behavior Description
1 Reserved for future use
2 Reserved for future use
3 Reserved for future use
4 Reserved for future use
5 Reserved for future use
6 Reserved for future use
7 Reserved for future use
8 Reserved for future use
Control Description
/ A forward slash symbol is used as a separator for the behavior and trace flag setting.
Trace Description
1 Display information about the input record upon the system console.
2 Display information about the Data Element segments of an input record upon the system console.
3 Write information about the Data Element segments of an input record to the SYS1MSGS file.
4 Write information about the an input record to the SYS1MSGS file.
5 Reserved for future use
6 Reserved for future use
7 Reserved for future use
8 Reserved for future use
  Program and Trace Flags
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.

Table of Contents Previous Section Next Section 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.

Table of Contents Previous Section Next Section 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.

Table of Contents Previous Section Next Section 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.

Link to Internet   Link to Server   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.

Table of Contents Previous Section Next Section 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 document and the links to other documents are intended to provide a greater awareness of the Data Management and Application Processing alternatives.

The 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 send an e-mail to: helpdesk@simotime.com or call 415 883-6565. We appreciate hearing from you.

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

Table of Contents Previous Section Next Section 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.

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

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

Table of Contents Previous Section Next Section 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 Micro Focus Web Site for more information about products and services available from Micro Focus. This link requires an Internet Connection.

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 or Feedback

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

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

We appreciate hearing from you.

Table of Contents Previous Section Next Section 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 at 1 415 827-7045 or send an e-mail to: helpdesk@simotime.com

Also, check the web site at http://www.simotime.com


Return-to-Top
MC T112 File Conversion
Copyright © 1987-2019
SimoTime Technologies and Services
All Rights Reserved
When technology complements business
http://www.simotime.com