Item Master File
http://www.simotime.com
| |
EBCDIC to ASCII Conversion Item Master File http://www.simotime.com |
| When technology complements business | Copyright © 1987-2012 SimoTime Enterprises All Rights Reserved |
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).
This is actually two COBOL programs. The first program does the File I/O of reading the EBCDIC encoded Item Master File and the writing to a new ASCII encoded Item Master File. The File I/O program calls the second program to do the EBCDIC to ASCII conversion of the records within the file. The COBOL programs were generated by SimoTime technology using a COBOL copy file that defines the record layout.. The genration of the programs is done on a Windows system running Micro Focus COBOL. However, since the generated COBOL source code is COBOL/2 compliant it may be compiled and executed on an IBM Mainframe, a Windows system with Micro Focus or a UNIX system with Micro Focus.
The term Mainframe-Oriented refers to an actual IBM Mainframe, Micro Focus Mainframe Express or Micro Focus Enterprise Server with the Mainframe Transaction Option and the Batch Facility. The following (ITME2AJ1.JCL) is a listing of the JCL member needed to run this job.
//ITME2AJ1 JOB SIMOTIME,ACCOUNT,CLASS=1,MSGCLASS=0,NOTIFY=CSIP1
//* *******************************************************************
//* This program is provided by: *
//* SimoTime Enterprises, LLC *
//* (C) Copyright 1987-2010 All Rights Reserved *
//* Web Site URL: http://www.simotime.com *
//* e-mail: helpdesk@simotime.com *
//* *******************************************************************
//*
//* Text - Execute a COBOL program to read VSAM and write VSAM.
//* Author - SimoTime Enterprises
//* Date - January 01, 1997
//*
//* This COBOL program will read a VSAM, KSDS, EBCDIC, 512-byte,
//* record-length file and write a KSDS, VSAM ASCII-encoded data set.
//*
//* ************
//* * ITME2AJ1 *
//* ********jcl*
//* *
//* *
//* ************ ************ ************
//* * ITMGETDE *-----* ITME2AC1 *-----* ITMPUTDA *
//* *******ksds* ********cbl* *******ksds*
//* *
//* *
//* ************
//* * EOJ *
//* ************
//*
//* *******************************************************************
//* Step 1 This is a single step job.
//*
//CUCRTS01 EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
DEFINE CLUSTER (NAME(SIMOTIME.DATA.ITEMASC1) -
TRACKS(45,15) -
INDEXED) -
DATA (NAME(SIMOTIME.DATA.ITEMASC1.DAT) -
KEYS(12,0) -
RECORDSIZE(512,512) -
FREESPACE(10,15) -
CISZ(8192)) -
INDEX (NAME(SIMOTIME.DATA.ITEMASC1.IDX))
//* *******************************************************************
//* Step 2 This is a single step job.
//*
//ITME2AS1 EXEC PGM=ITME2AC1
//STEPLIB DD DISP=SHR,DSN=SIMOTIME.DEMO.LOADLIB1
//ITMGETDE DD DISP=SHR,DSN=SIMOTIME.DATA.ITEMMAST
//ITMPUTDA DD DISP=SHR,DSN=SIMOTIME.DATA.ITEMASC1
//*
The following (ITME2AC1.CBL) is the COBOL I/O program that was generated with SimoTime technology. The program was tested using Micro Focus Enterprise Server on Windows/XP. The program were successfully executed in both an EBCDIC and ASCII encoded configuration.
IDENTIFICATION DIVISION.
PROGRAM-ID. ITME2AC1.
AUTHOR. SIMOTIME ENTERPRISES.
*****************************************************************
* This program was generated by SimoZAPS *
* A product of SimoTime Enterprises *
* Our e-mail address is: helpdesk@simotime.com *
* Also, visit our Web Site at http://www.simotime.com *
* *
* Generation Date: 2007-02-17 Generation Time: 01:29:26:34 *
* *
* Record Record Key *
* Function Name Organization Format Max-Min Pos-Len *
* INPUT ITMGETDE INDEXED VARIABLE 00512 00001 *
* 00012 *
* OUTPUT ITMPUTDA INDEXED VARIABLE 00512 00001 *
* 00012 *
* *
* Translation Mode is EBCDIC to ASCII *
* *
*****************************************************************
ENVIRONMENT DIVISION.
INPUT-OUTPUT SECTION.
FILE-CONTROL.
SELECT ITMGETDE-FILE ASSIGN TO ITMGETDE
ORGANIZATION IS INDEXED
ACCESS MODE IS SEQUENTIAL
RECORD KEY IS ITMGETDE-KEY-01
FILE STATUS IS ITMGETDE-STATUS.
SELECT ITMPUTDA-FILE ASSIGN TO ITMPUTDA
ORGANIZATION IS INDEXED
ACCESS MODE IS SEQUENTIAL
RECORD KEY IS ITMPUTDA-KEY-01
FILE STATUS IS ITMPUTDA-STATUS.
*****************************************************************
DATA DIVISION.
FILE SECTION.
FD ITMGETDE-FILE
DATA RECORD IS ITMGETDE-REC
.
01 ITMGETDE-REC.
05 ITMGETDE-KEY-01 PIC X(00012).
05 ITMGETDE-DATA-01 PIC X(00500).
FD ITMPUTDA-FILE
DATA RECORD IS ITMPUTDA-REC
.
01 ITMPUTDA-REC.
05 ITMPUTDA-KEY-01 PIC X(00012).
05 ITMPUTDA-DATA-01 PIC X(00500).
*****************************************************************
* This program was created using the SYSMASK3.TXT file as the *
* template for the File I/O. It is intended for use with the *
* TransCALL facility that makes a call to a routine that does *
* the actual conversion between EBCDIC and ASCII. For more *
* information or questions contact SimoTime Enterprises. *
* *
* Our e-mail address is: helpdesk@simotime.com *
* Also, visit our Web Site at http://www.simotime.com *
* *
* The SYSMASK3 provides for the sequential reading of the input *
* file and the sequential writing of the output file. *
* If the output file is indexed then the input file must be in *
* sequence by the field that will be used to provide the key *
* for the output file. *
* *
* If the key field is not in sequence then refer to SYSMASK4 *
* to provide for a random add or update of the indexed file. *
*****************************************************************
WORKING-STORAGE SECTION.
01 SIM-TITLE.
05 T1 pic X(11) value '* ITME2AC1 '.
05 T2 pic X(34) value 'Data Migration and Conversion '.
05 T3 pic X(10) value 'v05.12.23 '.
05 T4 pic X(24) value ' http://www.simotime.com'.
01 SIM-COPYRIGHT.
05 C1 pic X(11) value '* ITME2AC1 '.
05 C2 pic X(20) value 'Created by SimoZAPS,'.
05 C3 pic X(20) value ' a utility package '.
05 C4 pic X(28) value 'of SimoTime Enterprises, LLC'.
01 ITMGETDE-STATUS.
05 ITMGETDE-STATUS-L pic X.
05 ITMGETDE-STATUS-R pic X.
01 ITMGETDE-EOF pic X value 'N'.
01 ITMGETDE-OPEN-FLAG pic X value 'C'.
01 ITMPUTDA-STATUS.
05 ITMPUTDA-STATUS-L pic X.
05 ITMPUTDA-STATUS-R pic X.
01 ITMPUTDA-EOF pic X value 'N'.
01 ITMPUTDA-OPEN-FLAG pic X value 'C'.
01 ITMGETDE-LRECL pic 9(5) value 00512.
01 ITMPUTDA-LRECL pic 9(5) value 00512.
*****************************************************************
* The following buffers are used to create a four-byte status *
* code that may be displayed. *
*****************************************************************
01 IO-STATUS.
05 IO-STAT1 pic X.
05 IO-STAT2 pic X.
01 IO-STATUS-04.
05 IO-STATUS-0401 pic 9 value 0.
05 IO-STATUS-0403 pic 999 value 0.
01 TWO-BYTES-BINARY pic 9(4) BINARY.
01 TWO-BYTES-ALPHA redefines TWO-BYTES-BINARY.
05 TWO-BYTES-LEFT pic X.
05 TWO-BYTES-RIGHT pic X.
*****************************************************************
* Message Buffer used by the Z-DISPLAY-MESSAGE-TEXT routine. *
*****************************************************************
01 MESSAGE-BUFFER.
05 MESSAGE-HEADER pic X(11) value '* ITME2AC1 '.
05 MESSAGE-TEXT.
10 MESSAGE-TEXT-1 pic X(68) value SPACES.
10 MESSAGE-TEXT-2 pic X(188) value SPACES.
*****************************************************************
01 PROGRAM-NAME pic X(8) value 'ITME2AC1'.
01 APPL-RESULT pic S9(9) comp.
88 APPL-AOK value 0.
88 APPL-EOF value 16.
01 ITMGETDE-TOTAL.
05 ITMGETDE-RDR pic 9(9) value 0.
05 filler pic X(3) value ' - '.
05 filler pic X(23) value 'Line count for ITMGETDE'.
01 ITMPUTDA-TOTAL.
05 ITMPUTDA-ADD pic 9(9) value 0.
05 filler pic X(3) value ' - '.
05 filler pic X(23) value 'Line count for ITMPUTDA'.
*****************************************************************
PROCEDURE DIVISION.
perform Z-POST-COPYRIGHT
perform ITMGETDE-OPEN
perform ITMPUTDA-OPEN
perform until ITMGETDE-STATUS not = '00'
perform ITMGETDE-READ
if ITMGETDE-STATUS = '00'
add 1 to ITMGETDE-RDR
perform BUILD-OUTPUT-RECORD
perform ITMPUTDA-WRITE
if ITMPUTDA-STATUS = '00'
add 1 to ITMPUTDA-ADD
end-if
end-if
end-perform
move ITMGETDE-TOTAL to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
move ITMPUTDA-TOTAL to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
if APPL-EOF
move 'is Complete...' to MESSAGE-TEXT
else
move 'is ABENDING...' to MESSAGE-TEXT
end-if
perform Z-DISPLAY-MESSAGE-TEXT
perform ITMPUTDA-CLOSE
perform ITMGETDE-CLOSE
GOBACK.
*****************************************************************
BUILD-OUTPUT-RECORD.
*> TransMODE is E2A...
*> TransCALL process...
move ITMGETDE-REC to ITMPUTDA-REC
call 'ITME2AR1' using ITMPUTDA-REC
add 00512 to ZERO giving ITMPUTDA-LRECL
exit.
*****************************************************************
* I/O Routines for the INPUT File... *
*****************************************************************
ITMGETDE-CLOSE.
add 8 to ZERO giving APPL-RESULT.
close ITMGETDE-FILE
if ITMGETDE-STATUS = '00'
subtract APPL-RESULT from APPL-RESULT
else
add 12 to ZERO giving APPL-RESULT
end-if
if APPL-AOK
CONTINUE
else
move 'CLOSE Failure with ITMGETDE' to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
move ITMGETDE-STATUS to IO-STATUS
perform Z-DISPLAY-IO-STATUS
perform Z-ABEND-PROGRAM
end-if
exit.
*---------------------------------------------------------------*
ITMGETDE-READ.
read ITMGETDE-FILE
if ITMGETDE-STATUS = '00'
subtract APPL-RESULT from APPL-RESULT
else
if ITMGETDE-STATUS = '10'
add 16 to ZERO giving APPL-RESULT
else
add 12 to ZERO giving APPL-RESULT
end-if
end-if
if APPL-AOK
CONTINUE
else
if APPL-EOF
move 'Y' to ITMGETDE-EOF
else
move 'READ Failure with ITMGETDE' to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
move ITMGETDE-STATUS to IO-STATUS
perform Z-DISPLAY-IO-STATUS
perform Z-ABEND-PROGRAM
end-if
end-if
exit.
*---------------------------------------------------------------*
ITMGETDE-OPEN.
add 8 to ZERO giving APPL-RESULT.
open input ITMGETDE-FILE
if ITMGETDE-STATUS = '00'
subtract APPL-RESULT from APPL-RESULT
move 'O' to ITMGETDE-OPEN-FLAG
else
add 12 to ZERO giving APPL-RESULT
end-if
if APPL-AOK
CONTINUE
else
move 'OPEN Failure with ITMGETDE' to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
move ITMGETDE-STATUS to IO-STATUS
perform Z-DISPLAY-IO-STATUS
perform Z-ABEND-PROGRAM
end-if
exit.
*****************************************************************
* I/O Routines for the OUTPUT File... *
*****************************************************************
ITMPUTDA-WRITE.
if ITMPUTDA-OPEN-FLAG = 'C'
perform ITMPUTDA-OPEN
end-if
write ITMPUTDA-REC
if ITMPUTDA-STATUS = '00'
subtract APPL-RESULT from APPL-RESULT
else
if ITMPUTDA-STATUS = '10'
add 16 to ZERO giving APPL-RESULT
else
add 12 to ZERO giving APPL-RESULT
end-if
end-if.
if APPL-AOK
CONTINUE
else
move 'WRITE Failure with ITMPUTDA' to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
move ITMPUTDA-STATUS to IO-STATUS
perform Z-DISPLAY-IO-STATUS
perform Z-ABEND-PROGRAM
end-if
exit.
*---------------------------------------------------------------*
ITMPUTDA-OPEN.
add 8 to ZERO giving APPL-RESULT.
open OUTPUT ITMPUTDA-FILE
if ITMPUTDA-STATUS = '00'
subtract APPL-RESULT from APPL-RESULT
move 'O' to ITMPUTDA-OPEN-FLAG
else
add 12 to ZERO giving APPL-RESULT
end-if
if APPL-AOK
CONTINUE
else
move 'OPEN Failure with ITMPUTDA' to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
move ITMPUTDA-STATUS to IO-STATUS
perform Z-DISPLAY-IO-STATUS
perform Z-ABEND-PROGRAM
end-if
exit.
*---------------------------------------------------------------*
ITMPUTDA-CLOSE.
add 8 to ZERO giving APPL-RESULT.
close ITMPUTDA-FILE
if ITMPUTDA-STATUS = '00'
subtract APPL-RESULT from APPL-RESULT
move 'C' to ITMPUTDA-OPEN-FLAG
else
add 12 to ZERO giving APPL-RESULT
end-if
if APPL-AOK
CONTINUE
else
move 'CLOSE Failure with ITMPUTDA' to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
move ITMPUTDA-STATUS to IO-STATUS
perform Z-DISPLAY-IO-STATUS
perform Z-ABEND-PROGRAM
end-if
exit.
*****************************************************************
* The following Z-ROUTINES provide administrative functions *
* for this program. *
*****************************************************************
* ABEND the program, post a message to the console and issue *
* a STOP RUN. *
*****************************************************************
Z-ABEND-PROGRAM.
if MESSAGE-TEXT not = SPACES
perform Z-DISPLAY-MESSAGE-TEXT
end-if
move 'PROGRAM-IS-ABENDING...' to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
add 12 to ZERO giving RETURN-CODE
STOP RUN.
* exit.
*****************************************************************
* Display CONSOLE messages... *
*****************************************************************
Z-DISPLAY-MESSAGE-TEXT.
if MESSAGE-TEXT-2 = SPACES
display MESSAGE-BUFFER(1:79)
else
display MESSAGE-BUFFER
end-if
move all SPACES to MESSAGE-TEXT
exit.
*****************************************************************
* Display the file status bytes. This routine will display as *
* four digits. If the full two byte file status is numeric it *
* will display as 00nn. If the 1st byte is a numeric nine (9) *
* the second byte will be treated as a binary number and will *
* display as 9nnn. *
*****************************************************************
Z-DISPLAY-IO-STATUS.
if IO-STATUS not NUMERIC
or IO-STAT1 = '9'
move IO-STAT1 to IO-STATUS-04(1:1)
subtract TWO-BYTES-BINARY from TWO-BYTES-BINARY
move IO-STAT2 to TWO-BYTES-RIGHT
add TWO-BYTES-BINARY to ZERO giving IO-STATUS-0403
move 'File Status is: nnnn' to MESSAGE-TEXT
move IO-STATUS-04 to MESSAGE-TEXT(17:4)
perform Z-DISPLAY-MESSAGE-TEXT
else
move '0000' to IO-STATUS-04
move IO-STATUS to IO-STATUS-04(3:2)
move 'File Status is: nnnn' to MESSAGE-TEXT
move IO-STATUS-04 to MESSAGE-TEXT(17:4)
perform Z-DISPLAY-MESSAGE-TEXT
end-if
exit.
*****************************************************************
Z-POST-COPYRIGHT.
display SIM-TITLE
display SIM-COPYRIGHT
exit.
*****************************************************************
* This program was generated by SimoZAPS *
* A product of SimoTime Enterprises *
* Our e-mail address is: helpdesk@simotime.com *
* Also, visit our Web Site at http://www.simotime.com *
* *
* Generation Date: 2007-02-17 Generation Time: 01:29:26:34 *
*****************************************************************
The following (ITME2AR1.CBL) is a COBOL program that converts a record based on the record layout defined in a COBOL copy file. The program was tested using Micro Focus Enterprise Server on Windows/XP. The program were successfully executed in both an EBCDIC and ASCII encoded configuration.
IDENTIFICATION DIVISION.
PROGRAM-ID. ITME2AR1.
AUTHOR. SIMOTIME ENTERPRISES.
*****************************************************************
* This routine was generated by SimoREC1 *
* A product of SimoTime Enterprises *
* Our e-mail address is: helpdesk@simotime.com *
* Also, visit our Web Site at http://www.simotime.com *
* Generation Date: 2007/02/17 Generation Time: 01:29:26:16 *
*****************************************************************
DATA DIVISION.
WORKING-STORAGE SECTION.
01 IX-1 PIC 9(5) VALUE 0.
01 RM-1 PIC 9(5) VALUE 0.
01 RO-1 PIC 9(5) VALUE 0.
01 IX-2 PIC 9(5) VALUE 0.
01 RM-2 PIC 9(5) VALUE 0.
01 RO-2 PIC 9(5) VALUE 0.
COPY ASCEBCB1.
COPY ASCEBCB2.
*****************************************************************
LINKAGE SECTION.
COPY ITEMCB01.
*****************************************************************
PROCEDURE DIVISION using ITEM-RECORD.
inspect ITEM-NUMBER converting E-INFO to A-INFO
inspect ITEM-DESCRIPTION converting E-INFO to A-INFO
* Binary ITEM-QTY-ONHAND
* Binary ITEM-QTY-ALLOCATED
inspect ITEM-UNIT-OF-MEASURE converting E-INFO to A-INFO
* Packed ITEM-COST
* Packed ITEM-PRICE
inspect ITEM-LADATE converting E-INFO to A-INFO
inspect ITEM-LATIME converting E-INFO to A-INFO
inspect ITEM-TOKEN converting E-INFO to A-INFO
inspect ITEM-D-CODE-1 converting E-INFO to A-INFO
* Decimal ITEM-D-PERCENT-1
inspect ITEM-RECORD(115:7) converting E-NUMB to A-NUMB
inspect ITEM-D-CODE-2 converting E-INFO to A-INFO
* Decimal ITEM-D-PERCENT-2
inspect ITEM-RECORD(123:7) converting E-NUMB to A-NUMB
inspect ITEM-D-CODE-3 converting E-INFO to A-INFO
* Decimal ITEM-D-PERCENT-3
inspect ITEM-RECORD(131:7) converting E-NUMB to A-NUMB
* Filler A Non-Unique Reference to a Data Item
inspect ITEM-RECORD(138:375) converting E-INFO to A-INFO
GOBACK.
The purpose of this program is to provide an example of how to convert an EBCDIC-encoded Indexed file to an ASCII-encoded Indexed file and maintain mainframe numeric integrity.
Permission to use, copy, modify and distribute this software for any commercial purpose requires a fee to be paid to Simotime Enterprises. Once the fee is received by SimoTime the latest version of the software 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.
Permission to use, copy, modify and distribute this software for a non-commercial purpose and without fee is hereby granted, 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 for any purpose. It is provided "AS IS" without any express 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.
This suite of programs is part of the File Maintenance package for the Item Master File. You may download this at http://www.simotime.com/sim4dzip.htm#itmast01 or view the complete list of SimoTime Examples at http://www.simotime.com/sim4dzip.htm .
Note: You must be attached to the Internet to download a Z-Pack or view the list.
The SimoZAPS Utility Program has the capability of generating a COBOL program that will do the conversion of sequential and VSAM (KSDS) files between EBCDIC and ASCII. SimoZAPS can also read a sequential file in EBCDIC format and create an ASCII/CRLF file or VSAM KSDS file in ASCII format. The conversion tables may be viewed or modified to meet unique requirements. The Hexcess/2 function provides the capability of viewing, finding or patching the contents of a file in hexadecimal.
This item will provide a link to an ASCII or EBCDIC translation table. A column for decimal, hexadecimal and binary is also included.
Check out The VSAM - QSAM Connection for more examples of mainframe VSAM and QSAM accessing techniques and sample code.
This document provides a quick summary of the File Status Key for VSAM data sets and QSAM files.
To review all the information available on this site start at The SimoTime Home Page .
Check out The SimoTime Glossary for a list of terms and definitions used in the documents provided by SimoTime.
If you have any questions, suggestions or comments please call or send an e-mail to: helpdesk@simotime.com
We appreciate your comments and feedback.
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 complimentary 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 |
| Copyright © 1987-2012 SimoTime Enterprises All Rights Reserved |
| When technology complements business |
| http://www.simotime.com |
| Version 06.11.01 |