Vancouver Utilities Details Mainframe Migration Tools to convert

Vancouver Utilities - Details • Mainframe Migration Tools to convert – JCL, COBOL, & DATA • General Purpose Data Utilities – For Unix, Linux, or Windows • Replacements for Mainframe Utilities – SORT/SYNCSORT replaced by uvsort – IEBGENER/IDCAMS replaced by uvcp www. uvsoftware. ca

5 Parts to Conversion 1. 2. 3. 4. 5. JCL conversion to Korn shell scripts COBOL porting to Micro Focus Data conversion EBCDIC to ASCII VU Testing & Debugging Aids Mainframe Data Utility Replacements www. uvsoftware. ca

JCL Conversion - Highlights • • • DDN/DSN converted to Export DDN=DSN SORT/SYNCSORT converted to ‘uvsort’ IEBGENER/IDCAMS converted to ‘uvcp’ GDG files converted to ksh functions Console logging Micro Focus COBOL animation made easy Replacements for Ditto, Dyl 280, Easytrieve $RUNDATA/$RUNLIBS testing/production Laser scripts, 132 cols x 66 lines on 8½ x 11 www. uvsoftware. ca

Notes re Hyperlinked Samples • Hyperlinked samples begin on next slide – Click hyperlinks (Red) to view sample files – Returning to slide depends on your browser • IE – use your back button, do not kill – IE displays both PPT & HTML samples • Fire. Fox – kill the browser (X) – Firefox downloads PPT to run on your desktop – And honors the hyperlinks to samples on web www. uvsoftware. ca

JCL Conversion Example #1 • sample JCL & script (1 step COBOL) • Korn shell script equivalent www. uvsoftware. ca

JCL Conversion Ex#2 (SORT) • Sample SORT conversion to uvsort - original mainframe SORT step - equivalent uvsort in ksh script www. uvsoftware. ca

Sync. Sort conversion to uvsort • • Syncsort functionality at lower cost INCLUDEs, OMITs, SUMs, OUTREC, etc. Uvsort sels, dels, sums, mvcs, etc. sample INCLUDE AND/OR conditions www. uvsoftware. ca

JCL Conversion #3 (GDG files) • GDG files supported by ksh functions • exportgen 0, exportgen 1, exportgenp • sample JCL & script with GDG files www. uvsoftware. ca

IEBGENER & IDCAMS • • IEBGENER converted to ‘uvcp’ IDCAMS REPRO converted to ‘uvcp’ IEBGENER & IDCAMS JCL sample Korn shell script equivalent www. uvsoftware. ca

COBOL porting to Micro Focus • Not much to do, but saves manual editing • Insert EXTERNAL on select/assign stmts • Translate to lower case except in quotes – more modern appearance – easier to edit with unix/linux editors (vi, etc) • Insert detail file status test code – For Micro Focus extended file status display www. uvsoftware. ca

Data Conversion • Translate EBCDIC to ASCII – Preserving packed/binary fields – Correcting zoned signs to ASCII standards • Conversion jobs generated from copybooks – and LISTCAT file specs • 1 script to generate all conversion jobs • 1 command to convert all data files www. uvsoftware. ca

Data Conversion Example • Conversions generated from copybooks Sample copybook (citytax 1. cpy) • Cob. Map record layout from copybook Sample cobmap (citytax. map) • Data conversion job (uvcopy) Sample uvcopy data conversion (citytax 1. uv) www. uvsoftware. ca

Data File specs from LISTCAT • LISTCAT info completes conversions – added to copybook/cobmap/uvcopy job – Data filename, file type, Indexed keys Sample LISTCAT & extracted control file uvcopy job completed by control file www. uvsoftware. ca

Converting files for RDBMS • Convert data to pipe delimited text files – Packed/binary fields edited signs & decimals • Packed/binary fields unpacked & edited – Conversion jobs auto-gen’d from copybooks • • SQL loader control file also generated Sample pipe delimited output file Sample uvcopy job to perform pipe delimit Sample loader control file www. uvsoftware. ca

Conversion Directories • For JCL, COBOL, & Data conversions • Conversion Libraries • Data directories for testing or production • sample test data subdirs www. uvsoftware. ca

Scripts convert All JCL/COBOL/DATA • jcl 2 ksh 5 A – convert All JCL to ksh • cnv. MF 5 A – convert all COBOL to Micro Focus • gencnv. C - generate all Data conversion jobs • uvcopyxx pfx 2/* - execute all data convert jobs www. uvsoftware. ca

Scripts to convert 1 JCL/COBOL/Data. File • jcl 2 ksh 51 – convert 1 JCL to ksh • cnv. MF 51 – convert 1 program to Micro. Focus • gencnv. B – convert 1 datafile to ASCII • genpipe. A – convert 1 file to pipe-delimited • uvcopy pfx 3/datafilename – execute 1 conversion job www. uvsoftware. ca

Testing & Debugging Aids • uvhd & uvhdcob – data file investigation – Browse, search, update, print, etc • uvhd – sample EBCDIC file display – uvhd dat 1 ebc/custmas 1 r 256 s 3 a • uvhd – sample ASCII file display – uvhd dat 2 asc/custmas 1 r 256 s 3 • uvhdcob – sample record display – uvhdcob dat 2 asc/custmas 1 maps/custmas 1 www. uvsoftware. ca

COBOL Cross-References • • xcobcall 1 – list called programs in each program xcobcall 2 – crossref programs calling any 1 program xcobcopy 1 – list copybooks in each program xcobcopy 2 – crossref programs using any 1 copybook - please see xcobcopy 2 (most useful cross-reference) • cobfiles - COBOL files report – organization, access, open-mode, recsize, copybook, www. uvsoftware. ca

JCL Cross-References • • xjkshfile 1 – list datafiles in each JCL/script xjkshfile 2 – crossref programs using any 1 datafile xjkshprog 1 – list programs in each JCL/script xjkshprog 2 – crossref JCL/scripts using any 1 program • Jobflow reports – generated from JCL+COBOL • Show file I/O from step to step in multi-step jobs – Sample jobflow report www. uvsoftware. ca

Converting DYL 280 to uv… • Sample#1 – file init (write 1 blank/zero rec) Mainframe DYL 280 code Equivalent uvcp Equivalent uvcopy • Sample#2 – add records to an indexed file Mainframe DYL 280 code Equivalent uvcopy www. uvsoftware. ca

Pre-Programmed uvcopy jobs • table 2 – table summaries by arguments – Table entries limited only by memory – Table dumped at EOF in argument sequence – Percentages on every line of 100% total line • • Sample input data file Sample table summary report Operating instructions & console displays uvcopy job equivalent www. uvsoftware. ca

Replacements for Mainframe Utilities • (Dyl 280, Easytrieve, Quik. Job, Ditto, etc) • uvqrpg – Report Generator – up to 8 control break fields & total levels – up to 100 accumulators per level – built in sort • Sample input file • Sample output report • Sample uvqrpg code www. uvsoftware. ca

End of Conversion Details • Thank You for your interest in the Vancouver Utilities for Mainframe Conversion • Also see Conversion Overview at: www. uvsoftware. ca/ppt/MFconvert 1. pps • Return to UV Software Home-Page: www. uvsoftware. ca