Create & Maintain a VSAM, KSDS
|
Customer Master File Create & Maintain a VSAM, KSDS |
|
| The SimoTime Home Page |
Introduction
Many of the sample programs provided by SimoTime Enterprises use a "Customer Master File" to get data that is used to demonstrate various processing or data accessing techniques. This suite of sample programs describes how to create this "Customer Master File". On the IBM Mainframe the Customer Master File is an EBCDIC-encoded 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. In the Micro Focus world on Linux, UNIX or Windows the file content may be EBCDIC or ASCII encoded.
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 is defined in a COBOL copy file and contains text strings and various numeric formats including zoned-decimal, packed and binary.
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-2016
SimoTime Technologies
All Rights Reserved
Programming Objectives
This suite of programs will illustrate the following functions.
| ||||||||||||||
| Programming Objectives |
Programming Requirements
This suite of sample programs will run on the following platforms.
| ||||||
| Programming Requirements |
Programming Overview
This suite of sample programs will run on the following platforms
| ||||||||
| Programming Overview |
JCL to Manage a Customer Master File
The JCL provided with this suite of programs will run in a Mainframe-Oriented Environment. The term "Mainframe-Oriented Environment" is used to refer to the following.
| ||||||||
| Mainframe-Oriented Environments |
The Record Structure
The record structure for the Customer Master File is defined using a COBOL COPY File (or COPY Book). The COPY File provides the basic information for an application program. However, determining the position and physical lengths of the fields within a record would require some additional calculation. Therefore, we have included a link to a separate document that explicitly provides this information. The document is generated using the COBOL COPY File.
Record Structure, a COBOL Copy File
The following (CUSTCB01.cpy) shows the content of the COPY File.
*****************************************************************
* CUSTCB01.CPY - a COBOL Copy File *
* A Customer Master File used by the Demo programs. *
* This is a VSAM Keyed-Sequential-Data-Set or Key-Indexed File. *
* Copyright (C) 1987-2016 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 *
*****************************************************************
* The length of this data structure is 512 bytes.
*
01 CUST-RECORD.
05 CUST-NUMBER PIC X(12).
05 CUST-DATA.
10 CUST-STATUS PIC X.
10 CUST-NAME.
15 CUST-LAST-NAME PIC X(28).
15 CUST-FIRST-NAME PIC X(20).
15 CUST-MID-NAME PIC X(20).
10 CUST-ADDRESS-1 PIC X(48).
10 CUST-ADDRESS-2 PIC X(48).
10 CUST-CITY PIC X(28).
10 CUST-STATE PIC X(28).
10 CUST-POSTAL-CODE PIC X(12).
10 CUST-PHONE-HOME PIC X(18).
10 CUST-PHONE-WORK PIC X(18).
10 CUST-PHONE-CELL PIC X(18).
10 CUST-CREDIT-LIMIT PIC 9(7) COMP-3.
10 CUST-DISCOUNT OCCURS 3 TIMES.
15 CUST-DISCOUNT-CODE PIC S9(3) COMP.
15 CUST-DISCOUNT-RATE PIC S9(2)V999.
15 CUST-DISCOUNT-DATE PIC X(8).
10 CUST-LADATE PIC X(8).
10 CUST-LATIME PIC X(8).
10 CUST-TOKEN PIC 9(3).
10 FILLER PIC X(145).
*
*** CUSTCB01 - End-of-Copy File - - - - - - - - - - - CUSTCB01 *
*****************************************************************
*
Record Structure, an HTML Document
The Record Structure for the Customer Master file is defined in an HTML document that is generated using a COBOL copy file. The COBOL copy file provides information for an application program to build a data structure in Working Storage. However, the copy file 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.
Defining the VSAM Cluster
The following (CUSCRTJ1.jcl) is a listing of the JCL member that may be used to create the Customer Master File.
//CUSCRTJ1 JOB SIMOTIME,CLASS=1,MSGCLASS=0,NOTIFY=CSIP1
//* *******************************************************************
//* CUSCRTJ1.JCL - a JCL Member for Batch Job Processing *
//* This JCL Member is provided by SimoTime Technologies *
//* (C) Copyright 1987-2016 All Rights Reserved *
//* Web Site URL: http://www.simotime.com *
//* e-mail: helpdesk@simotime.com *
//* *******************************************************************
//*
//* Text - Create an empty VSAM, KSDS data set using IDCAMS.
//* Author - SimoTime Technologies
//* Date - January 24, 1996
//*
//* This job will create a VSAM, KSDS data set. The key is twelve
//* characters starting at the first position in the record.
//* The record length is 512 characters.
//*
//* This set of programs will run on a mainframe under MVS or on a
//* Personal Computer with Windows and Micro Focus Mainframe Express.
//*
//* *******************************************************************
//* Step 1 This is a single step job.
//*
//KSDSMAKE EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
DEFINE CLUSTER (NAME(SIMOTIME.DATA.CUSTMAST) -
TRACKS(45,15) -
INDEXED) -
DATA (NAME(SIMOTIME.DATA.CUSTMAST.DAT) -
KEYS(12,0) -
RECORDSIZE(512,512) -
FREESPACE(10,15) -
CISZ(8192)) -
INDEX (NAME(SIMOTIME.DATA.CUSTMAST.IDX))
/*
//*
Load and Update Data Sets for Testing
Once the VSAM Cluster has been defined it will be necessary to load data (i.e. add records to the file) into the data set. The following sub-sections will describe and demonstrate some of the alternatives available.
Load a Small Data Set
The following two JCL members will create a sequential file of eighty (80) byte records with each record containing a six (6) byte customer number and customer data. The sequential file will then be read and the information will be reformatted to a twelve (12) byte customer number with larger data fields. The reformatted data will then be used to update records in the Customer Master File.
JCL to Create a Sequential File with Customer Data (Record Reformatting)
The following (CUSC80J1.jcl) is a listing of the JCL member that may be used to create a sequential file using instream data. The sequential file may be used to update the Customer Master File.
//CUSC80J1 JOB SIMOTIME,CLASS=1,MSGCLASS=0,NOTIFY=CSIP1 //* ******************************************************************* //* CUSC80J1.JCL - a JCL Member for Batch Job Processing * //* This JCL Member is provided by SimoTime Technologies * //* (C) Copyright 1987-2016 All Rights Reserved * //* Web Site URL: http://www.simotime.com * //* e-mail: helpdesk@simotime.com * //* ******************************************************************* //* //* Text - Create a Sequential Data Set on disk using IEBGENER. //* Author - SimoTime Technologies //* Date - January 24, 1996 //* //* The first job step (QSAMDELT) will delete any previously created //* file. The second job step (QSAMCRT1) will create a new file. //* //* This set of programs will run on a mainframe under MVS or on a //* Personal Computer with Windows and Micro Focus Mainframe Express. //* //* ************ //* * QUSC80J1 * //* ********jcl* //* * //* * //* ************ ************ //* * IEFBR14 ******* CUST0080 * //* ********utl* ***delete*** //* * //* * //* ************ ************ ************ //* * SYSIN ******* IEBGENER ******* CUST0080 * //* ********jcl* ********utl* *******rseq* //* * //* * //* ************ //* * EOJ * //* ************ //* //* ******************************************************************* //* Step 1 of 2 Delete any previously created file... //* //QSAMDELT EXEC PGM=IEFBR14 //CUST0080 DD DSN=SIMOTIME.DATA.CUST0080,DISP=(MOD,DELETE,DELETE), // STORCLAS=MFI, // SPACE=(TRK,5), // DCB=(RECFM=FB,LRECL=80,BLKSIZE=800,DSORG=PS) //* //* ******************************************************************* //* Step 2 of 2 Create and populate a new QSAM file... //* //QSAMCRT1 EXEC PGM=IEBGENER //SYSPRINT DD SYSOUT=* //SYSIN DD DUMMY //* :....1....:....2....:....3....:....4....:....5....:....6....:....7. ..:....8 //SYSUT1 DD * 000100 Anderson Adrian 1113 Peachtree Plaza Atlanta GA 26101 000200 Brown Billie 224 Baker Boulevard Baltimore MD 35702 000300 Carson Cameron 336 Crenshaw Blvd. Cupertino CA 96154 000400 Davidson Dion 448 Main Street Wilmington DE 27323 000500 Everest Evan 55 5TH Avenue New York NY 10341 000600 Franklin Francis 6612 66TH Avenue Bedrock NY 11903 000700 Garfunkel Gwen 777 77TH Street New York NY 16539 000800 Harrison Hilary 888 88TH Street Pocatello ID 79684 000900 Isley Isabel 999 99TH Avenue Indianapolis IN 38762 001000 Johnson Jamie 1010 Paradise Drive Larkspur CA 90504 001100 Kemper Kelly 1111 Oak Circle Kansas City KS 55651 001200 Lemond Lesley 1212 Lockwood Road Mohave Desert AZ 80303 001300 Mitchell Marlowe 1313 Miller Creek Road Anywhere TX 77123 001400 Newman Noel 1414 Park Avenue Santa Monica CA 90210 001500 Osborn Owen 1515 Center Stage Rolling Rock PA 36613 001600 Powell Pierce PO Box 1616 Ventura CA 97712 001700 Quigley Quincy 1717 Farm Hill Road Oshkosh WI 43389 001800 Ripley Ray 1818 Alien Lane Wayout KS 55405 001900 Smith Sammy 1919 Carnoustie Drive Novato CA 94919 002000 Tucker Taylor 2020 Sanger Lane St. Paul MN 43998 002100 Underwood Ulysses 2121 Wall Street New York NY 17623 002200 Van Etten Valerie 2222 Vine Street Hollywood CA 98775 002300 Wilson Wiley 2323 Main Street Boston MA 01472 002400 Xray Xavier 2424 24TH Street Nashville TN 44190 002500 Young Yanni 2525 Yonge Street Toronto ON 6B74A6 002600 Zenith Zebulon 2626 26TH Street Dallas TX 71922 123456 Doe John 123 Main Street Anywhere OR 88156 /* //SYSUT2 DD DSN=SIMOTIME.DATA.CUST0080, // DISP=(NEW,CATLG,DELETE), // STORCLAS=MFI, // SPACE=(TRK,5), // DCB=(RECFM=FB,LRECL=80,BLKSIZE=800,DSORG=PS) //
JCL to Update the Customer Master File (Record Reformatting)
The following (CUSI80J1.jcl) is a listing of the JCL member that may be used to update the Customer Master File.
//CUSI80J1 JOB SIMOTIME,ACCOUNT,CLASS=1,MSGCLASS=0,NOTIFY=&SYSUID //* ******************************************************************* //* CUSI80J1.JCL - a JCL Member for Batch Job Processing * //* This JCL Member is provided by SimoTime Technologies * //* (C) Copyright 1987-2016 All Rights Reserved * //* Web Site URL: http://www.simotime.com * //* e-mail: helpdesk@simotime.com * //* ******************************************************************* //* //* Text - Read 80-Byte input and populate a VSAM, KSDS. //* Author - SimoTime Technologies //* Date - November 24, 2004 //* Version - 07.01.22 //* //* This job uses a COBOL program to read a sequential file. The //* information is then used to add records to the KSDS. The records //* must be in sequence determined by the key field. //* //* ******************************************************************* //* Step 1 of 1 Read Sequential File, add records to VSAM, KSDS. //* //STEP010 EXEC PGM=CUSI80C1 //STEPLIB DD DSN=SIMOTIME.DEMO.LOADLIB1,DISP=SHR //CUST0080 DD DSN=SIMOTIME.DATA.CUST0080, // DISP=SHR //CUSTMAST DD DSN=SIMOTIME.DATA.CUSTMAST, // DISP=SHR //SYSOUT DD SYSOUT=* //*
Load a Large Data Set (User Defines Number of Records)
The following two JCL members will do an intial load and a secondary update/add of records to the Customer Master File.
Check out How to Create and Populate a Customer Master File for the Development and Testing environments. This suite of programs will allow the user to determine the number of records to be added to the Customer Master File.
JCL, Populate a New Customer File (Sequential Load)
The following is the mainframe JCL (OBFADDJ1.jcl) required to sequentially load (or add) records to a new Customer Master File.
//OBFADDJ1 JOB SIMOTIME,ACCOUNT,CLASS=1,MSGCLASS=0,NOTIFY=CSIP1 //* ******************************************************************* //* This JCL Member is provided by SimoTime Technologies * //* (C) Copyright 1987-2016 All Rights Reserved * //* Web Site URL: http://www.simotime.com * //* e-mail: helpdesk@simotime.com * //* ******************************************************************* //* //* Text - Execute a COBOL program to populate a Customer File. //* Author - SimoTime Technologies //* Date - January 01, 1997 //* //* This COBOL program will read a control file and access the various //* name files to populate or update a customer master file. //* //* This program uses a Sequential ADD methodology. Therefore, //* the records being added to the file need to be in sequence //* by the record key. Since this does an OPEN for OUTPUT it is used //* to create a new file. //* //* ************ //* * OBFADDJ1 * //* ********jcl* //* * //* * //* ************ ************ ************ //* * OBFCTL80 *--*--* OBFDATC2 *-----* OBF1CUST * //* *******rseq* * ********cbl* *******ksds* //* * * //* ************ * * //* * LASTNAME *--* * //* *******rseq* * * //* * * //* ************ * * //* * FNAMEF01 *--* * //* *******rseq* * * //* * * //* ************ * * //* * FNAMEM01 *--* * //* *******rseq* * * //* * * //* ************ * * //* * POSTCODE *--* * //* *******rseq* * * //* * * //* ************ * * //* * STREET01 *--* * //* *******rseq* * //* * //* ************ //* * EOJ * //* ************ //* //* ******************************************************************* //* Step 1 This is a single step job. //* //CUADDS01 EXEC PGM=OBFDATC2 //STEPLIB DD DISP=OLD,DSN=MFI01.SIMOPROD.LOADLIB1 //OBFCTL80 DD DISP=OLD,DSN=SIMOTIME.DATA.OBFCTL80 //FNAMEF01 DD DISP=OLD,DSN=SIMOTIME.DATA.FNAMEF01 //FNAMEM01 DD DISP=OLD,DSN=SIMOTIME.DATA.FNAMEM01 //LASTNAME DD DISP=OLD,DSN=SIMOTIME.DATA.LASTNAME //POSTCODE DD DISP=OLD,DSN=SIMOTIME.DATA.POSTCODE //STREET01 DD DISP=OLD,DSN=SIMOTIME.DATA.STREET01 //OBF1CUST DD DISP=OLD,DSN=SIMOTIME.DATA.OBF1CUST //SYSOUT DD SYSOUT=* //*
JCL, Update or Add Records to an Existing Customer File (Random Access)
The following is the mainframe JCL (OBFUPDJ1.jcl) required to add new records or update existing records for the Customer Master File.
//OBFUPDJ1 JOB SIMOTIME,ACCOUNT,CLASS=1,MSGCLASS=0,NOTIFY=CSIP1 //* ******************************************************************* //* This JCL Member is provided by SimoTime Technologies * //* (C) Copyright 1987-2016 All Rights Reserved * //* Web Site URL: http://www.simotime.com * //* e-mail: helpdesk@simotime.com * //* ******************************************************************* //* //* Text - Execute a COBOL program to update a Customer File. //* Author - SimoTime Technologies //* Date - January 01, 1997 //* //* This COBOL program will read a control file and access the various //* name files to populate or update a customer master file. //* //* This program uses a Random, ADD/UPDATE methodology. Therefore, //* the records being added to the file do not need to be in //* sequence by the record key. //* //* ************ //* * OBFUPDJ1 * //* ********jcl* //* * //* * //* ************ ************ //* * OBFDATC1 *-----* OBF1CUST * //* ********cbl* *******ksds* //* * //* ************ ************ //* * OBFCTL80 *--*--* OBFCTLC1 * //* *******rseq* ********cbl* //* * //* ************ ************ //* * LASTNAME *--*--* OBFDATR1 * //* *******rseq* * ********cbl* //* * * //* ************ * * //* * FNAMEF01 *--* * //* *******rseq* * * //* * * //* ************ * * //* * FNAMEM01 *--* * //* *******rseq* * * //* * * //* ************ * * //* * POSTCODE *--* * //* *******rseq* * * //* * * //* ************ * * //* * STREET01 *--* * //* *******rseq* * //* * //* ************ //* * EOJ * //* ************ //* //* ******************************************************************* //* Step 1 This is a single step job. //* //CUUPDS01 EXEC PGM=OBFDATC1 //STEPLIB DD DISP=OLD,DSN=MFI01.SIMOPROD.LOADLIB1 //OBFCTL80 DD DISP=OLD,DSN=SIMOTIME.DATA.OBFCTL80 //FNAMEF01 DD DISP=OLD,DSN=SIMOTIME.DATA.FNAMEF01 //FNAMEM01 DD DISP=OLD,DSN=SIMOTIME.DATA.FNAMEM01 //LASTNAME DD DISP=OLD,DSN=SIMOTIME.DATA.LASTNAME //POSTCODE DD DISP=OLD,DSN=SIMOTIME.DATA.POSTCODE //STREET01 DD DISP=OLD,DSN=SIMOTIME.DATA.STREET01 //OBF1CUST DD DISP=OLD,DSN=SIMOTIME.DATA.OBF1CUST //SYSOUT DD SYSOUT=* //*
Updating Fields within a Record
The following two JCL members will create a sequential file with each record containing a field identifier, a customer number and a string of data. The sequential file will then be read and the information will be used to update fields within records of the Customer Master File.
JCL to Create a Sequential File with Customer Data (Field Level)
The following (CUCSQJ01.jcl) is a listing of the JCL member that may be used to create a sequential file using instream data. The sequential file may be used to update the Customer Master File.
//CUCSQJ01 JOB SIMOTIME,CLASS=1,MSGCLASS=0,NOTIFY=CSIP1 //* ******************************************************************* //* CUCSQJ01.JCL - a JCL Member for Batch Job Processing * //* This JCL Member is provided by SimoTime Technologies * //* (C) Copyright 1987-2016 All Rights Reserved * //* Web Site URL: http://www.simotime.com * //* e-mail: helpdesk@simotime.com * //* ******************************************************************* //* //* Text - Create a Sequential Data Set on disk using IEBGENER. //* Author - SimoTime Technologies //* Date - January 24, 1996 //* //* The first job step (SQ01DELT) will delete any previously created //* file. The second job step (CUCSQS01) will create a new file. //* //* This set of programs will run on a mainframe under MVS or on a //* Personal Computer with Windows and Micro Focus Mainframe Express. //* //* ************ //* * CUCSQJ01 * //* ********jcl* //* * //* * //* ************ ************ //* * IEFBR14 ******* CUSTSQ01 * //* ********utl* ***delete*** //* * //* * //* ************ ************ ************ //* * SYSUT2 ******* IEBGENER ******* CUSTSQ01 * //* ********jcl* ********utl* *******qsam* //* * //* * //* ************ //* * EOJ * //* ************ //* //* ******************************************************************* //* Positions Purpose/Description //* 01-03 Control Information //* 04-15 Key for KSDS Access //* 15-71 Text string used for update //* //* *** ************************ //* /NL update CUST-LAST-NAME //* /NF update CUST-FIRST-NAME //* /NM update CUST-MIDDLE-NAME //* /A1 update CUST-ADDRESS-1 //* /A2 update CUST-ADDRESS-2 //* /CT update CUST-CITY //* /ST update CUST-STATE //* /PC update CUST-POSTAL-CODE //* /CL update CUST-CREDIT-LIMIT //* /TH update CUST-PHONE-HOME //* /TO update CUST-PHONE-OFFICE //* /TM update CUST-PHONE-MOBILE //* //* ******************************************************************* //* Step 1 of 2 Delete any previously created file... //* //SQ01DELT EXEC PGM=IEFBR14 //CUSTSQ01 DD DSN=SIMOTIME.DATA.CUSTSQ01,DISP=(MOD,DELETE,DELETE), // STORCLAS=MFI, // SPACE=(TRK,5), // DCB=(RECFM=FB,LRECL=80,BLKSIZE=800,DSORG=PS) //* //* ******************************************************************* //* Step 2 of 2 Create and populate a new QSAM file... //* //CUCSQS01 EXEC PGM=IEBGENER //SYSPRINT DD SYSOUT=* //SYSIN DD DUMMY //* :....1....:....2....:....3....:....4....:....5....:....6....:....7....:....8 //SYSUT1 DD * /NL000000000001Anderson /NF000000000001Adrian /A1000000000001111 Peachtree Plaza /CT000000000001Atlanta /ST000000000001GA /PC00000000000111033 /TO0000000000012651101234 /CL0000000000010025000 /NL000000000002Brown /NF000000000002Billie /A1000000000002222 Baker Boulevard /A2000000000002Apartment 22B /CT000000000002Baltimore /ST000000000002MD /PC00000000000221033 /CL0000000000020002500 /NL000000000003Carson /NF000000000003Cameron /A1000000000003333 Crenshaw Blvd. /CT000000000003Cupertino /ST000000000003CA /PC00000000000394116 /NL000000000004Davidson /NF000000000004Dion /A1000000000004444 Main Street /CT000000000004Wilmington /ST000000000004DE /PC00000000000410421-6767 /NL000000000005Everest /NF000000000005Evan /A1000000000005555 5TH Avenue /CT000000000005New York /ST000000000005NY /PC00000000000512135 /NL000000000006Franklin /NF000000000006Francis /A1000000000006666 66TH Avenue /CT000000000006Bedrock /ST000000000006NY /PC00000000000613897 /NL000000000007Garfunkel /NF000000000007Gwen /A1000000000007777 77TH Street /CT000000000007New York /ST000000000007NY /PC00000000000711397 /NL000000000008Harrison /NF000000000008Hilary /A1000000000008888 88TH Street /CT000000000008Pocatello /ST000000000008ID /PC00000000000878662 /NL000000000009Isley /NF000000000009Isabel /A1000000000009999 99TH Avenue /CT000000000009Indianapolis /ST000000000009IN /PC00000000000937912 /NL000000000010Johnson /NF000000000010Jamie /A10000000000101010 Paradise Drive /CT000000000010Larkspur /ST000000000010CA /PC00000000001097661 /NL000000000011Kemper /NF000000000011Kelly /A10000000000111111 Oak Circle /CT000000000011Kansas City /ST000000000011KS /PC00000000001143077 /NL000000000012Lemond /NF000000000012Lesley /A10000000000121212 Lockwood Road /A2000000000012Suite 12A /CT000000000012Mohave Desert /ST000000000012AZ /PC00000000001287033 /NL000000000013Mitchell /NF000000000013Marlow /A10000000000131313 Miller Creek Road /CT000000000013Anywhere /ST000000000013TX /PC00000000001361773 /NL000000000014Newman /NF000000000014Noel /A10000000000141414 Park Avenue /CT000000000014Santa Monica /ST000000000014CA /PC00000000001490503 /NL000000000015Osborn /NF000000000015Owen /A10000000000151515 Center Stage /CT000000000015Rolling Rock /ST000000000015PA /PC00000000001527113 /NL000000000016Powell /NF000000000016Pierce /A1000000000016PO Box 1616 /CT000000000016Ventura /ST000000000016CA /PC00000000001690507 /NL000000000017Quigley /NF000000000017Quincy /A10000000000171717 Farm Hill Road /CT000000000017Oshkosh /ST000000000017WI /PC00000000001706112 /NL000000000018Ripley /NF000000000018Ray /A10000000000181818 Alien Lane /CT000000000018Wayout /ST000000000018KS /PC00000000001804713 /NL000000000019Smith /NF000000000019Sammy /A10000000000191919 Carnoustie Drive /CT000000000019Novato /ST000000000019CA /PC00000000001994949 /TO000000000019415 883-6565 /CL0000000000190010000 /NL000000000020Tucker /NF000000000020Taylor /A10000000000202020 Sanger Lane /CT000000000020St. Paul /ST000000000020MN /PC00000000002006147 /CL0000000000201234567 /NL000000000021Underwood /NF000000000021Ulysses /A10000000000212121 Wall Street /CT000000000021New York /ST000000000021NY /PC00000000002104001 /NL000000000022Van Etten /NF000000000022Valerie /A10000000000222222 Vine Street /A200000000002216TH Floor /CT000000000022Hollywood /ST000000000022CA /PC00000000002297163 /NL000000000023Wilson /NF000000000023Wiley /A10000000000232323 Main Street /CT000000000023Boston /ST000000000023MA /PC00000000002327135 /NL000000000024Xray /NF000000000024Xavier /A10000000000242424 24TH Street /CT000000000024Nashville /ST000000000024TN /PC00000000002450513 /NL000000000025Young /NF000000000025Yanni /A10000000000252525 Yonge Street /CT000000000025Toronto /ST000000000025ON /PC0000000000251K3 B4R /NL000000000026Zenith /NF000000000026Zebulon /A10000000000262626 26TH Street /CT000000000026Dallas /ST000000000026TX /PC00000000002661735 /* //SYSUT2 DD DSN=SIMOTIME.DATA.CUSTSQ01, // DISP=(NEW,CATLG,DELETE), // STORCLAS=MFI, // SPACE=(TRK,5), // DCB=(RECFM=FB,LRECL=80,BLKSIZE=800,DSORG=PS) //
JCL to Update the Customer Master File (Field Level)
The following (CUUPDJ01.jcl) is a listing of the JCL member that may be used to update the Customer Master File.
//CUUPDJ01 JOB SIMOTIME,ACCOUNT,CLASS=1,MSGCLASS=0,NOTIFY=CSIP1 //* ******************************************************************* //* CUUPDJ01.JCL - a JCL Member for Batch Job Processing * //* This JCL Member is provided by SimoTime Technologies * //* (C) Copyright 1987-2016 All Rights Reserved * //* Web Site URL: http://www.simotime.com * //* e-mail: helpdesk@simotime.com * //* ******************************************************************* //* //* Text - Execute a COBOL program to read QSAM and write VSAM. //* Author - SimoTime Technologies //* Date - January 01, 1997 //* //* This COBOL program will read a QSAM, EBCDIC, 80-byte, //* fixed-record-length file and update a KSDS, VSAM data set. //* //* ************ //* * CUUPDJ01 * //* ********jcl* //* * //* * //* ************ ************ ************ //* * CUSTSQ01 *-----* CUUPDC01 *-----* CUSTMAST * //* *******qsam* ********cbl* *******vsam* //* * //* * //* ************ //* * EOJ * //* ************ //* //* ******************************************************************* //* Step 1 This is a single step job. //* //CUUPDS01 EXEC PGM=CUUPDC01 //STEPLIB DD DISP=SHR,DSN=MFI01.SIMOPROD.LOADLIB1 //CUSTSQ01 DD DISP=SHR,DSN=SIMOTIME.DATA.CUSTSQ01 //CUSTMAST DD DISP=SHR,DSN=SIMOTIME.DATA.CUSTMAST //SYSOUT DD SYSOUT=* //*
JCL to Extract Data from Customer Master File for use by Microsoft Excel
The following (CUSEXTJ1.JCL) is a listing of the JCL member that may be used to extract information from the Customer Master File and create a sequential file with the records formatted with the fields delimited by a comma.
//CUSEXTJ1 JOB SIMOTIME,ACCOUNT,CLASS=1,MSGCLASS=0,NOTIFY=CSIP1 //* ******************************************************************* //* CUSEXTJ1.JCL - a JCL Member for Batch Job Processing * //* This JCL Member is provided by SimoTime Technologies * //* (C) Copyright 1987-2016 All Rights Reserved * //* Web Site URL: http://www.simotime.com * //* e-mail: helpdesk@simotime.com * //* ******************************************************************* //* //* Text - Read Customer Master File, write to a sequential file //* Author - SimoTime Technologies //* Date - January 01, 1989 //* //* This set of programs will run on a mainframe under MVS or on //* a Personal Computer running Windows and Mainframe Express by //* Micro Focus. //* //* ************ ************ //* * Entry * * Entry * //* * MVS * * Windows * //* ************ ************ //* * * //* ************ ************ //* * CUSEXTJ1 * * CUSEXTE1 * //* ********jcl* ********cmd* //* * * //* ************ * //* * IEFBR14 * * //* ********utl* * //* * * //* ********************************* //* * //* * //* ************ ************ ************ //* * CUSTMAST *----* CUSEXTC1 *----* CUSEXTSV * //* ************ ********cbl* ********dat* //* * * //* * * //* * *---CALL----* //* * * //* * * //* * ************ //* * * CUSEXTR1 * //* * ********cbl* //* * //* ************ //* * EOJ * //* ************ //* //* ******************************************************************* //* Step 1 of 2, This job step will delete a previously created file. //* //DELTSEQ1 EXEC PGM=IEFBR14 //CUSTRCSV DD DSN=SIMOTIME.DATA.CUSTPHON,DISP=(MOD,DELETE,DELETE), // STORCLAS=MFI, // SPACE=(TRK,5), // DCB=(RECFM=FB,LRECL=256,DSORG=PS) //* ******************************************************************* //* Step 2 of 2, Execute the Sample program. //* Read the customer file (KSDS) and write a record of //* selected fields to a sequential file. Truncate spaces //* from each field and separate the fields by a comma. //* //CBLEXTS1 EXEC PGM=CUSEXTC1 //STEPLIB DD DSN=MFI01.SIMOPROD.LOADLIB1,DISP=SHR //CUSTMAST DD DSN=SIMOTIME.DATA.CUSTMAST,DISP=SHR //CUSTRCSV DD DSN=SIMOTIME.DATA.CUSTPHON,DISP=(NEW,CATLG,DELETE), // STORCLAS=MFI, // SPACE=(TRK,5), // DCB=(RECFM=FB,LRECL=256,DSORG=PS) //SYSOUT DD SYSOUT=* //*
The COBOL Program Listings
This section includes a listing of the source code for the COBOL programs used to create, maintain and access the Customer Master File.
COBOL, Update the Customer Master File (Record Reformatting)
The following (CUSI80C1.cbl) is a sample COBOL demonstration program. This program will "read from" a sequential file and "update records or add records" to the Customer Master File. The sequential input file is eighty (80) byte fixed length records with a six (6) byte customer number in positions 1-6. The Customer number will be expanded to twelve (12) bytes and the individual fields will be increased in size. The program will compile and run in a Mainframe-oriented environment using an EBCDIC or ASCII encoded format.
IDENTIFICATION DIVISION.
PROGRAM-ID. CUSI80C1.
AUTHOR. SIMOTIME TECHNOLOGIES.
*****************************************************************
* This program was generated by SimoZAPS *
* A product of SimoTime Technologies *
* Our e-mail address is: helpdesk@simotime.com *
* Also, visit our Web Site at http://www.simotime.com *
* *
* Generation Date: 2010-07-07 Generation Time: 06:39:49:90 *
* *
* Record Record Key *
* Function Name Organization Format Max-Min Pos-Len *
* INPUT CUST0080 SEQUENTIAL FIXED 00080 *
* *
* OUTPUT CUSTMAST INDEXED VARIABLE 00512 00001 *
* 00012 00012 *
* *
* Translation Mode is ASCII to ASCII *
* *
*****************************************************************
ENVIRONMENT DIVISION.
INPUT-OUTPUT SECTION.
FILE-CONTROL.
SELECT CUST0080-FILE ASSIGN TO CUST0080
ORGANIZATION IS SEQUENTIAL
ACCESS MODE IS SEQUENTIAL
FILE STATUS IS CUST0080-STATUS.
SELECT CUSTMAST-FILE ASSIGN TO CUSTMAST
ORGANIZATION IS INDEXED
ACCESS MODE IS SEQUENTIAL
RECORD KEY IS CUSTMAST-PKEY-00001-00012
FILE STATUS IS CUSTMAST-STATUS.
*****************************************************************
DATA DIVISION.
FILE SECTION.
FD CUST0080-FILE
DATA RECORD IS CUST0080-REC
.
01 CUST0080-REC.
05 CUST0080-DATA-01 PIC X(00080).
FD CUSTMAST-FILE
DATA RECORD IS CUSTMAST-REC
.
01 CUSTMAST-REC.
05 CUSTMAST-PKEY-00001-00012 PIC X(00012).
05 CUSTMAST-DATA-00013-00500 PIC X(00500).
*****************************************************************
* This program was created with the SYSMASK1.TXT file as input. *
* The SYSMASK1 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. This is a sequential load process. *
* *
* If the key field is not in sequence then refer to SYSMASK2 *
* to provide for a random add or update of the indexed file. *
* *
* This program mask will have the ASCII/EBCDIC table inserted *
* for use by the /TRANSLATE function of SimoZAPS. *
* *
* For additional information contact SimoTime Technologies. *
* *
* Our e-mail address is: helpdesk@simotime.com *
* Also, visit our Web Site at http://www.simotime.com *
*****************************************************************
WORKING-STORAGE SECTION.
01 SIM-TITLE.
05 T1 pic X(11) value '* CUSI80C1 '.
05 T2 pic X(34) value 'Sequential, RSEQ-80 to KSEQ-512 '.
05 T3 pic X(10) value ' v10.07.06'.
05 T4 pic X(24) value ' helpdesk@simotime.com'.
01 SIM-COPYRIGHT.
05 C1 pic X(11) value '* CUSI80C1 '.
05 C2 pic X(32) value 'This Data File Convert Member wa'.
05 C3 pic X(32) value 's generated by SimoTime Technolo'.
05 C4 pic X(04) value 'gies'.
01 CUST0080-STATUS.
05 CUST0080-STATUS-L pic X.
05 CUST0080-STATUS-R pic X.
01 CUST0080-EOF pic X value 'N'.
01 CUST0080-OPEN-FLAG pic X value 'C'.
01 CUSTMAST-STATUS.
05 CUSTMAST-STATUS-L pic X.
05 CUSTMAST-STATUS-R pic X.
01 CUSTMAST-EOF pic X value 'N'.
01 CUSTMAST-OPEN-FLAG pic X value 'C'.
01 CUST0080-LRECL pic 9(5) value 00080.
01 CUSTMAST-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 '* CUSI80C1 '.
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 'CUSI80C1'.
01 INFO-STATEMENT.
05 INFO-SHORT.
10 INFO-ID pic X(8) value 'Starting'.
10 filler pic X(2) value ', '.
10 filler pic X(34)
value 'Sequential, RSEQ-80 to KSEQ-512 '.
05 filler pic X(24)
value ' http://www.SimoTime.com'.
01 APPL-RESULT pic S9(9) comp.
88 APPL-AOK value 0.
88 APPL-EOF value 16.
01 CUST0080-TOTAL.
05 CUST0080-RDR pic 9(9) value 0.
05 filler pic X(3) value ' - '.
05 filler pic X(23) value 'Line count for CUST0080'.
01 CUSTMAST-TOTAL.
05 CUSTMAST-ADD pic 9(9) value 0.
05 filler pic X(3) value ' - '.
05 filler pic X(23) value 'Line count for CUSTMAST'.
*****************************************************************
PROCEDURE DIVISION.
move all '*' to MESSAGE-TEXT-1
perform Z-DISPLAY-MESSAGE-TEXT
move INFO-STATEMENT to MESSAGE-TEXT-1
perform Z-DISPLAY-MESSAGE-TEXT
move all '*' to MESSAGE-TEXT-1
perform Z-DISPLAY-MESSAGE-TEXT
perform Z-POST-COPYRIGHT
perform CUST0080-OPEN
perform CUSTMAST-OPEN
perform until CUST0080-STATUS not = '00'
perform CUST0080-READ
if CUST0080-STATUS = '00'
add 1 to CUST0080-RDR
perform BUILD-OUTPUT-RECORD
perform CUSTMAST-WRITE
if CUSTMAST-STATUS = '00'
add 1 to CUSTMAST-ADD
end-if
end-if
end-perform
move CUST0080-TOTAL to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
move CUSTMAST-TOTAL to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
if APPL-EOF
move 'Complete' to INFO-ID
else
move 'ABENDING' to INFO-ID
end-if
move INFO-STATEMENT to MESSAGE-TEXT(1:79)
perform Z-DISPLAY-MESSAGE-TEXT
perform CUSTMAST-CLOSE
perform CUST0080-CLOSE
GOBACK.
*****************************************************************
BUILD-OUTPUT-RECORD.
*> TransMODE is A2A...
*> TransINIT process...
move ALL SPACES to CUSTMAST-REC
*> TransCOPY...
move CUST0080-REC(00001:00006) to CUSTMAST-REC(00007:00006)
*> TransCOPY...
move CUST0080-REC(00008:00015) to CUSTMAST-REC(00014:00015)
*> TransCOPY...
move CUST0080-REC(00023:00010) to CUSTMAST-REC(00042:00010)
*> TransCOPY...
move CUST0080-REC(00033:00024) to CUSTMAST-REC(00082:00024)
*> TransCOPY...
move CUST0080-REC(00057:00015) to CUSTMAST-REC(00178:00015)
*> TransCOPY...
move CUST0080-REC(00072:00003) to CUSTMAST-REC(00206:00003)
*> TransCOPY...
move CUST0080-REC(00075:00006) to CUSTMAST-REC(00234:00006)
*> TransFILL...
move
'000000'
to CUSTMAST-REC(00001:00006)
*> TransFILL...
move
X'0000250F'
to CUSTMAST-REC(00300:00004)
*> TransFILL...
move
X'0000'
to CUSTMAST-REC(00304:00002)
*> TransFILL...
move
'00000'
to CUSTMAST-REC(00306:00005)
*> TransFILL...
move
'00000000'
to CUSTMAST-REC(00311:00008)
*> TransFILL...
move
X'0000'
to CUSTMAST-REC(00319:00002)
*> TransFILL...
move
'00000'
to CUSTMAST-REC(00321:00005)
*> TransFILL...
move
'00000000'
to CUSTMAST-REC(00326:00008)
*> TransFILL...
move
X'0000'
to CUSTMAST-REC(00334:00002)
*> TransFILL...
move
'00000'
to CUSTMAST-REC(00336:00005)
*> TransFILL...
move
'00000000'
to CUSTMAST-REC(00341:00008)
*> TransFILL...
move
'20080124'
to CUSTMAST-REC(00349:00008)
*> TransFILL...
move
'13053000'
to CUSTMAST-REC(00357:00008)
*> TransFILL...
move
'000'
to CUSTMAST-REC(00365:00003)
exit.
*****************************************************************
* I/O Routines for the INPUT File... *
*****************************************************************
CUST0080-CLOSE.
add 8 to ZERO giving APPL-RESULT.
close CUST0080-FILE
if CUST0080-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 CUST0080' to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
move CUST0080-STATUS to IO-STATUS
perform Z-DISPLAY-IO-STATUS
perform Z-ABEND-PROGRAM
end-if
exit.
*---------------------------------------------------------------*
CUST0080-READ.
read CUST0080-FILE
if CUST0080-STATUS = '00'
subtract APPL-RESULT from APPL-RESULT
else
if CUST0080-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 CUST0080-EOF
else
move 'READ Failure with CUST0080' to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
move CUST0080-STATUS to IO-STATUS
perform Z-DISPLAY-IO-STATUS
perform Z-ABEND-PROGRAM
end-if
end-if
exit.
*---------------------------------------------------------------*
CUST0080-OPEN.
add 8 to ZERO giving APPL-RESULT.
open input CUST0080-FILE
if CUST0080-STATUS = '00'
subtract APPL-RESULT from APPL-RESULT
move 'O' to CUST0080-OPEN-FLAG
else
add 12 to ZERO giving APPL-RESULT
end-if
if APPL-AOK
CONTINUE
else
move 'OPEN Failure with CUST0080' to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
move CUST0080-STATUS to IO-STATUS
perform Z-DISPLAY-IO-STATUS
perform Z-ABEND-PROGRAM
end-if
exit.
*****************************************************************
* I/O Routines for the OUTPUT File... *
*****************************************************************
CUSTMAST-WRITE.
if CUSTMAST-OPEN-FLAG = 'C'
perform CUSTMAST-OPEN
end-if
write CUSTMAST-REC
if CUSTMAST-STATUS = '00'
subtract APPL-RESULT from APPL-RESULT
else
if CUSTMAST-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 CUSTMAST' to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
move CUSTMAST-STATUS to IO-STATUS
perform Z-DISPLAY-IO-STATUS
perform Z-ABEND-PROGRAM
end-if
exit.
*---------------------------------------------------------------*
CUSTMAST-OPEN.
add 8 to ZERO giving APPL-RESULT.
open OUTPUT CUSTMAST-FILE
if CUSTMAST-STATUS = '00'
subtract APPL-RESULT from APPL-RESULT
move 'O' to CUSTMAST-OPEN-FLAG
else
add 12 to ZERO giving APPL-RESULT
end-if
if APPL-AOK
CONTINUE
else
move 'OPEN Failure with CUSTMAST' to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
move CUSTMAST-STATUS to IO-STATUS
perform Z-DISPLAY-IO-STATUS
perform Z-ABEND-PROGRAM
end-if
exit.
*---------------------------------------------------------------*
CUSTMAST-CLOSE.
add 8 to ZERO giving APPL-RESULT.
close CUSTMAST-FILE
if CUSTMAST-STATUS = '00'
subtract APPL-RESULT from APPL-RESULT
move 'C' to CUSTMAST-OPEN-FLAG
else
add 12 to ZERO giving APPL-RESULT
end-if
if APPL-AOK
CONTINUE
else
move 'CLOSE Failure with CUSTMAST' to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
move CUSTMAST-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 Technologies *
* Our e-mail address is: helpdesk@simotime.com *
* Also, visit our Web Site at http://www.simotime.com *
* *
* Generation Date: 2010-07-07 Generation Time: 06:39:49:95 *
*****************************************************************
COBOL, Update the Customer Master File Field Level
The following (CUUPDC01.cbl) is a sample COBOL demonstration program. This program will "read from" a sequential file and "update records or add records" to the Customer Master File. The program will compile and run in a Mainframe-oriented environment using an EBCDIC or ASCII encoded format.
IDENTIFICATION DIVISION.
PROGRAM-ID. CUUPDC01.
AUTHOR. SIMOTIME TECHNOLOGIES.
*****************************************************************
* Copyright (C) 1987-2016 SimoTime Technologies. *
* *
* All rights reserved. Unpublished, all rights reserved under *
* copyright law and international treaty. Use of a copyright *
* notice is precautionary only and does not imply publication *
* or disclosure. *
* *
* Permission to use, copy, modify and distribute this software *
* for any commercial purpose requires a fee to be paid to *
* SimoTime Technologies. 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 *
* Technologies. *
* *
* Permission to use, copy and modify this software for any *
* 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 *
* Technologies. *
* *
* SimoTime Technologies makes no warranty or representations *
* about the suitability of the software 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 *
* *
* SimoTime Technologies *
* 15 Carnoustie Drive *
* Novato, CA 94949-5849 *
* 415.883.6565 *
* *
* RESTRICTED RIGHTS LEGEND *
* Use, duplication, or disclosure by the Government is subject *
* to restrictions as set forth in subparagraph (c)(1)(ii) of *
* the Rights in Technical Data and Computer Software clause at *
* DFARS 52.227-7013 or subparagraphs (c)(1) and (2) of *
* Commercial Computer Software - Restricted Rights at 48 *
* CFR 52.227-19, as applicable. Contact SimoTime Technologies, *
* 15 Carnoustie Drive, Novato, CA 94949-5849. *
* *
*****************************************************************
* This program is provided by SimoTime Technologies *
* Our e-mail address is: helpdesk@simotime.com *
* Also, visit our Web Site at http://www.simotime.com *
* *
*****************************************************************
*
*****************************************************************
* Source Member: CUUPDC01.CBL
* Copy Files: QQSMREC1.CPY
*****************************************************************
*
* CUUPDC01 - Execute CUUPDC01 to read a QSAM file and update
* a VSAM Keyed Sequential Data Set (KSDS).
*
* EXECUTION or CALLING PROTOCOL
* -----------------------------
* Use standard JCL to EXECUTE or ANIMATE.
*
* DESCRIPTION
* -----------
* This single COBOL program will read an 80-byte, EBCDIC, QSAM
* file an populate or update an empty or existing KSDS, VSAM
* data set.
*
* ************
* * KSDUPD *
* ********jcl*
* *
* *
* ************ ************ ************
* * CUSTSQ01 *-----* CUUPDC01 *-----* CUSTMAST *
* *******qsam* ********cbl* *******vsam*
* *
* *
* ************
* * EOJ *
* ************
*
*****************************************************************
* This program will read the input file and update the master
* file (SYSMLR2). The format of the input file (SYSMLR1) is
* as follows.
*
* Position Length Description...
* ------ ---- -----------------------------------------------
* 01 03 Record Idendifier
* /N1 Name change or correction
* /A1 Address change or correction (street)
* /CT City
* /ST State
* /PC Postal Code
* 04 12 The Key Field
* 16 nn Length based on Record Identifier
*
*****************************************************************
*
* MAINTENANCE
* -----------
* 1997/02/27 Simmons, Created program.
* 1997/02/27 Simmons, No changes to date.
*
*****************************************************************
*
ENVIRONMENT DIVISION.
INPUT-OUTPUT SECTION.
FILE-CONTROL.
*****************************************************************
SELECT CUSTSQ01-FILE
ASSIGN to CUSTSQ01
ORGANIZATION is SEQUENTIAL
ACCESS MODE is SEQUENTIAL
FILE STATUS is CUSTSQ01-STATUS.
SELECT CUSTMAST-FILE
ASSIGN to CUSTMAST
ORGANIZATION is indexed
ACCESS MODE is RANDOM
RECORD KEY is CUST-NUMBER
FILE STATUS is CUSTMAST-STATUS.
*****************************************************************
DATA DIVISION.
FILE SECTION.
*****************************************************************
FD CUSTSQ01-FILE
RECORD CONTAINS 80 CHARACTERS.
COPY QSMCPYB2.
FD CUSTMAST-FILE.
COPY CUSTCB01.
WORKING-STORAGE SECTION.
*****************************************************************
* Data-structure for Title and Copyright...
*****************************************************************
01 SIM-TITLE.
05 T1 pic X(11) value '* CUUPDC01 '.
05 T2 pic X(34) value ' Read CUSTSQ01, Update CUSTMAST '.
05 T3 pic X(10) value ' v07.02.21'.
05 T4 pic X(24) value ' http://www.simotime.com'.
01 SIM-COPYRIGHT.
05 C1 pic X(11) value '* CUUPDC01 '.
05 C2 pic X(20) value 'Copyright 1987-2016 '.
05 C3 pic X(28) value ' SimoTime Technologies '.
05 C4 pic X(20) value ' All Rights Reserved'.
01 SIM-THANKS-01.
05 C1 pic X(11) value '* CUUPDC01 '.
05 C2 pic X(32) value 'Thank you for using this program'.
05 C3 pic X(32) value ' provided from SimoTime Technolo'.
05 C4 pic X(04) value 'gies'.
01 SIM-THANKS-02.
05 C1 pic X(11) value '* CUUPDC01 '.
05 C2 pic X(32) value 'Please send all inquires or sugg'.
05 C3 pic X(32) value 'estions to the helpdesk@simotime'.
05 C4 pic X(04) value '.com'.
01 CUSTMAST-STATUS.
05 CUSTMAST-STAT1 pic X.
05 CUSTMAST-STAT2 pic X.
01 CUSTSQ01-STATUS.
05 CUSTSQ01-STAT1 pic X.
05 CUSTSQ01-STAT2 pic X.
01 IO-STATUS.
05 IO-STAT1 pic X.
05 IO-STAT2 pic X.
01 TWO-BYTES.
05 TWO-BYTES-LEFT pic X.
05 TWO-BYTES-RIGHT pic X.
01 TWO-BYTES-BINARY redefines TWO-BYTES pic 9(4) comp.
01 END-OF-FILE pic X(3) value 'NO '.
*****************************************************************
* Buffer used for posting messages to the console.
*****************************************************************
01 MESSAGE-BUFFER.
05 MESSAGE-HEADER pic X(11) value '* CUUPDC01 '.
05 MESSAGE-TEXT.
10 MESSAGE-TEXT-1 pic X(68) value SPACES.
10 MESSAGE-TEXT-2 pic X(188) value SPACES.
01 CUSTSQ01-FLAG pic X value 'N'.
01 WORK-07.
05 WORK-07-NUMB pic 9(7) value 0.
01 WX-7 pic 9(2) value 0.
01 APPL-RESULT pic S9(9) comp.
88 APPL-AOK value 0.
88 APPL-EOF value 16.
*****************************************************************
PROCEDURE DIVISION.
perform Z-POST-COPYRIGHT.
perform CUSTSQ01-OPEN.
perform CUSTMAST-OPEN.
perform until END-OF-FILE = 'YES'
if END-OF-FILE = 'NO '
perform CUSTSQ01-GET
if END-OF-FILE = 'NO '
move QSAM-B2-RECORD to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
move QSAM-B2-KEY to CUST-NUMBER
perform CUSTMAST-GET
perform EVALUATE-FIELD-TYPE
if CUSTSQ01-FLAG = 'Y'
if APPL-AOK
perform MOVE-QSAM-FIELD-TO-KSDS-RECORD
perform CUSTMAST-REWRITE
else
perform INITIALIZE-CUSTOMER-RECORD
move QSAM-B2-KEY to CUST-NUMBER
perform MOVE-QSAM-FIELD-TO-KSDS-RECORD
perform CUSTMAST-WRITE
end-if
end-if
end-if
end-if
end-perform.
perform CUSTMAST-CLOSE.
perform CUSTSQ01-CLOSE.
display 'CUUPDC01 CUSTMAST-HAS-BEEN-UPDATED'
display 'CUUPDC01 NORMAL-END-OF-JOB...'
perform Z-THANK-YOU.
GOBACK.
*****************************************************************
* The following routines are in alphabetic sequence. *
*****************************************************************
INITIALIZE-CUSTOMER-RECORD.
move all SPACES to CUST-RECORD
initialize CUST-RECORD
exit.
*****************************************************************
EVALUATE-FIELD-TYPE.
if QSAM-B2-ID = '/NM'
or QSAM-B2-ID = '/NL'
or QSAM-B2-ID = '/NF'
or QSAM-B2-ID = '/A1'
or QSAM-B2-ID = '/A2'
or QSAM-B2-ID = '/CT'
or QSAM-B2-ID = '/ST'
or QSAM-B2-ID = '/PC'
or QSAM-B2-ID = '/CL'
or QSAM-B2-ID = '/TH'
or QSAM-B2-ID = '/TO'
or QSAM-B2-ID = '/TM'
move 'Y' to CUSTSQ01-FLAG
else
move 'N' to CUSTSQ01-FLAG
end-if
exit.
*****************************************************************
MOVE-QSAM-FIELD-TO-KSDS-RECORD.
move 'Y' to CUSTSQ01-FLAG
evaluate QSAM-B2-ID
when '/NL' move QSAM-B2-DATA to CUST-LAST-NAME
when '/NF' move QSAM-B2-DATA to CUST-FIRST-NAME
when '/NM' move QSAM-B2-DATA to CUST-MID-NAME
when '/A1' move QSAM-B2-DATA to CUST-ADDRESS-1
when '/A2' move QSAM-B2-DATA to CUST-ADDRESS-2
when '/CT' move QSAM-B2-DATA to CUST-CITY
when '/ST' move QSAM-B2-DATA to CUST-STATE
when '/PC' move QSAM-B2-DATA to CUST-POSTAL-CODE
when '/CL' perform MOVE-CUST-CREDIT-LIMIT
when '/TH' move QSAM-B2-DATA to CUST-PHONE-HOME
when '/TO' move QSAM-B2-DATA to CUST-PHONE-WORK
when '/TM' move QSAM-B2-DATA to CUST-PHONE-CELL
when other move 'N' to CUSTSQ01-FLAG
end-evaluate
exit.
*****************************************************************
MOVE-CUST-CREDIT-LIMIT.
move QSAM-B2-DATA to WORK-07
perform until WORK-07(7:1) not = SPACE
perform varying WX-7 from 6 by -1 until WX-7 = 0
move WORK-07(WX-7:1) to WORK-07(WX-7 + 1:1)
end-perform
* move WORK-07(6:1) to WORK-07(7:1)
* move WORK-07(5:1) to WORK-07(6:1)
* move WORK-07(4:1) to WORK-07(5:1)
* move WORK-07(3:1) to WORK-07(4:1)
* move WORK-07(2:1) to WORK-07(3:1)
* move WORK-07(1:1) to WORK-07(2:1)
move ZERO to WORK-07(1:1)
end-perform
if WORK-07-NUMB is NUMERIC
add WORK-07-NUMB to ZERO giving CUST-CREDIT-LIMIT
else
move 'Credit Limit Update Error...' to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
end-if
exit.
*****************************************************************
* Routines to do a sequential read of the QSAM file. *
*****************************************************************
CUSTSQ01-GET.
read CUSTSQ01-FILE
if CUSTSQ01-STATUS = '00'
subtract APPL-RESULT from APPL-RESULT
else
if CUSTSQ01-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 'YES' to END-OF-FILE
else
move 'CUUPDC01 CUSTSQ01-FAILURE-GET...'
to MESSAGE-TEXT
move CUSTSQ01-STATUS to IO-STATUS
perform Z-DISPLAY-MESSAGE-TEXT
perform Z-DISPLAY-IO-STATUS
perform Z-ABEND-PROGRAM
end-if
end-if
exit.
*---------------------------------------------------------------*
CUSTSQ01-OPEN.
add 8 to ZERO giving APPL-RESULT.
open input CUSTSQ01-FILE
if CUSTSQ01-STATUS = '00'
subtract APPL-RESULT from APPL-RESULT
else
add 12 to ZERO giving APPL-RESULT
end-if
if APPL-AOK
CONTINUE
else
move 'CUUPDC01 CUSTSQ01-FAILURE-OPEN...'
to MESSAGE-TEXT
move CUSTSQ01-STATUS to IO-STATUS
perform Z-DISPLAY-MESSAGE-TEXT
perform Z-DISPLAY-IO-STATUS
perform Z-ABEND-PROGRAM
end-if
exit.
*---------------------------------------------------------------*
CUSTSQ01-CLOSE.
add 8 to ZERO giving APPL-RESULT.
close CUSTSQ01-FILE
if CUSTSQ01-STATUS = '00'
subtract APPL-RESULT from APPL-RESULT
else
add 12 to ZERO giving APPL-RESULT
end-if
if APPL-AOK
CONTINUE
else
move 'CUUPDC01, CUSTSQ01, FAILURE, CLOSE...'
to MESSAGE-TEXT
move CUSTSQ01-STATUS to IO-STATUS
perform Z-DISPLAY-MESSAGE-TEXT
perform Z-DISPLAY-IO-STATUS
perform Z-ABEND-PROGRAM
end-if
exit.
*****************************************************************
* Routines to do a read by KEY of the KSDS, VSAM Data Set. If *
* the read is successful then the record may be updated else a *
* new record may be added. *
*****************************************************************
CUSTMAST-GET.
read CUSTMAST-FILE
if CUSTMAST-STATUS = '00'
subtract APPL-RESULT from APPL-RESULT
else
if CUSTMAST-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 'YES' to END-OF-FILE
end-if
end-if
exit.
*---------------------------------------------------------------*
CUSTMAST-WRITE.
write CUST-RECORD
if CUSTMAST-STATUS = '00'
subtract APPL-RESULT from APPL-RESULT
else
if CUSTMAST-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 'YES' to END-OF-FILE
else
move 'CUUPDC01 CUSTMAST-FAILURE-WRITE...'
to MESSAGE-TEXT
move CUSTMAST-STATUS to IO-STATUS
perform Z-DISPLAY-MESSAGE-TEXT
perform Z-DISPLAY-IO-STATUS
perform Z-ABEND-PROGRAM
end-if
end-if
exit.
*---------------------------------------------------------------*
CUSTMAST-REWRITE.
REWRITE CUST-RECORD
if CUSTMAST-STATUS = '00'
subtract APPL-RESULT from APPL-RESULT
else
if CUSTMAST-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 'YES' to END-OF-FILE
else
move 'CUUPDC01 CUSTMAST-FAILURE-REWRITE...'
to MESSAGE-TEXT
move CUSTMAST-STATUS to IO-STATUS
perform Z-DISPLAY-MESSAGE-TEXT
perform Z-DISPLAY-IO-STATUS
perform Z-ABEND-PROGRAM
end-if
end-if
exit.
*---------------------------------------------------------------*
CUSTMAST-OPEN.
add 8 to ZERO giving APPL-RESULT.
open I-O CUSTMAST-FILE
if CUSTMAST-STATUS = '35'
move 'CUUPDC01 CUSTMAST-FAILURE-OPEN-IO...'
to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
move CUSTMAST-STATUS to IO-STATUS
perform Z-DISPLAY-IO-STATUS
move 'CUUPDC01 CUSTMAST-ATTEMPT-OPEN-OUTPUT...'
to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
open output CUSTMAST-FILE
end-if
if CUSTMAST-STATUS = '00'
subtract APPL-RESULT from APPL-RESULT
else
add 12 to ZERO giving APPL-RESULT
end-if
if APPL-AOK
CONTINUE
else
move 'CUUPDC01 CUSTMAST-FAILURE-OPEN...'
to MESSAGE-TEXT
move CUSTMAST-STATUS to IO-STATUS
perform Z-DISPLAY-MESSAGE-TEXT
perform Z-DISPLAY-IO-STATUS
perform Z-ABEND-PROGRAM
end-if
exit.
*---------------------------------------------------------------*
CUSTMAST-CLOSE.
add 8 to ZERO giving APPL-RESULT.
close CUSTMAST-FILE
if CUSTMAST-STATUS = '00'
subtract APPL-RESULT from APPL-RESULT
else
add 12 to ZERO giving APPL-RESULT
end-if
if APPL-AOK
CONTINUE
else
move 'CUUPDC01 CUSTMAST-FAILURE-CLOSE...'
to MESSAGE-TEXT
move CUSTMAST-STATUS to IO-STATUS
perform Z-DISPLAY-MESSAGE-TEXT
perform Z-DISPLAY-IO-STATUS
perform Z-ABEND-PROGRAM
end-if
exit.
*****************************************************************
* The following Z-Routines perform administrative tasks *
* 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 'CUUPDC01 PROGRAM-IS-ABENDING...' to MESSAGE-TEXT
perform Z-DISPLAY-MESSAGE-TEXT
add 12 to ZERO giving RETURN-CODE
STOP RUN.
*****************************************************************
* Display the file status bytes. This routine will display as *
* two digits if the full two byte file status is numeric. If *
* second byte is non-numeric then it will be treated as a *
* binary number. *
*****************************************************************
Z-DISPLAY-IO-STATUS.
if IO-STATUS not NUMERIC
or IO-STAT1 = '9'
subtract TWO-BYTES-BINARY from TWO-BYTES-BINARY
move IO-STAT2 to TWO-BYTES-RIGHT
display '* CUUPDC01 FILE-STATUS-' IO-STAT1 '/'
TWO-BYTES-BINARY
else
display '* CUUPDC01 FILE-STATUS-' IO-STATUS
end-if
exit.
*****************************************************************
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.
*****************************************************************
Z-POST-COPYRIGHT.
display SIM-TITLE
display SIM-COPYRIGHT
exit.
*****************************************************************
Z-THANK-YOU.
display SIM-THANKS-01
display SIM-THANKS-02
exit.
*****************************************************************
* This example is provided by SimoTime Technologies *
* Our e-mail address is: helpdesk@simotime.com *
* Also, visit our Web Site at http://www.simotime.com *
*****************************************************************
COBOL, Extract Data from Customer Master File for use by Microsoft 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.
This link is provided to view the file extract programs that are provided in a separate document.
COBOL, Convert a Customer Master File (from EBCDIC to 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.
This link is provided to view the file extract programs that are provided in a separate document.
COBOL, Convert File Format
This is a single COBOL program. The program does the File I/O of reading a record sequential file and writing to a line sequential file (Micro Focus terminology for an ASCII/Text file).
This link is provided to view the file extract programs that are provided in a separate document.
COBOL, Convert File Format and Record Content
This is actually two COBOL programs. The first program does the File I/O of reading a record sequential file and writing to a line sequential file (Micro Focus terminology for an ASCII/Text file). The File I/O program calls the second program to do the EBCDIC to ASCII conversion of the 256 byte record.
This link is provided to view the file extract programs that are provided in a separate document.
Diagnostic Aids
This section provides access to documents with sample programs that will describe and demonstrate how to create and/or use tools that will assist in the validation and review of data structures that contain customer information.
Hex-Dump of Customer Master
This is an interesting program that would have required an assembler routine prior to the introduction of COBOL/2 for the mainframe. This program reads the Customer Master File that is a VSAM, Keyed-Sequential-Data-Set (KSDS) and writes a variable-length, sequential file that contains hexadecimal information. Records to be written to the Hex-Dump file are selected based on a list of primary keys in a control file.
Explore How to Create Hexadecimal Dump information for the records in a Customer Master file. The Customer Master file is a VSAM, KSDS. This document describes a process for generating a COBOL program that will read a VSAM/KSDS and write hexadecimal dump information to a sequential file. The user may define the records to be dumped by providing a list of primary keys in a control file.
Summary
The purpose of this document is to assist 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 documents and the links to other documents are intended to provide a choice of alternatives.
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.
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 non-Relational Data Connection for more examples of accessing methodologies and coding techniques for Data Files and VSAM Data Sets.
Explore How to Create and Populate a Customer Master File with generic test data. This document describes a simple process for creating test data for a customer master file. This simple process may be used with a traditional Record Sequential File, a VSAM Data Set or a Relational Data Base Table.
Explore How to Create a New or Update an Existing Customer Data Set that is a VSAM Key-Sequenced-Data-Set (KSDS). This document will describe the jobs and programs that create and maintain a Customer Data Set. The program will run on an IBM Mainframe System or a Linux, UNIX or Windows System with Micro Focus COBOL Support.
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.
Explore The File Status Return Codes to interpret the results of accessing VSAM data sets and/or QSAM files.
Internet Access Required
The following links will require an internet connect.
This suite of programs and documentation is available to download for review and evaluation purposes. Other uses will require a SimoTime Software License. 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 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.
Glossary of Terms
Explore the Glossary of Terms for a list of terms and definitions used in this suite of documents and white papers.
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 or send an e-mail to: helpdesk@simotime.com
We appreciate hearing from you.
Company Overview
Founded in 1987, SimoTime Technologies 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 |
| Customer Master File, Creation and Maintenance of a VSAM, KSDS |
| Copyright © 1987-2016 SimoTime Technologies All Rights Reserved |
| When technology complements business |
| http://www.simotime.com |