WORKBENCH

WORKBENCH
USER
MANUAL

VERSION

6.17

COPYRIGHT NOTICE

Copyright 2011. All rights to this publication are reserved. Readers arepermitted to reproduce, store in a retrieval system, or transmit this documentfor internal company/personal use under the condition that it is not for profit.

Any other usage requires prior permission from SystechSoftware Products, Inc., 256 Buli Lane Bolingbrook, Illinois 60490, (630)759-4805.

Systech reserves the right to make changes or improvements tothe software and documentation herein described at any time and without notice.

CONTENTS

SECTION A

CONTENTS 3

COMMAND CROSS REFERENCE 8

TOPIC CROSS REFERENCE 11

RESERVED VARIABLES 11

PREFACE 13

INTRODUCTION SECTION B

   FEATURES                        1

   PROCESS RULES                   2

   SUMMARY OF VERBS                3

COMMANDS SECTION C

        SYNTAX EXPLANATION              1

   COMMAND SUMMARY                 2



   ACCEPT   (idms)                 9

   ADD                             10

   BIND     (idms)                 11

   CALL                            12

   COMMENTS                      13

   COMMIT   (idms)                 14

   COMPARE                         15

   COMPRESS                        16

   COMPSRC                         17

   CVTBIN                          19

   CVTCHAR                         20

   CVTDEC                          21

   DB2-CONNECT (db2)               22

   DB2-DISCONNECT (db2)            23

   DECODE                          24

   DECOMPRESS                      25

   DEFAREA                         26

   DEFINES                         27

   DELETE                          29

   DIVIDE                          xx

   DLILINK                         30

   DUMP/DUMPV                      32

   DUMPH                           33

   DYNALLOC                        xx

   DYNCLOSE                        xx

   DYNOPEN                         xx

   EDIT                            34

   ENCODE                          35

   ENTRY                           30

   ERASE (idms)                    36

   EXEC SQL .... END-EXEC (db2)    37

   EXHIBIT                         38

   FIND (idms)                     39

   FINISH (idms)                   41

   GET (idms)                      42

   GOTO                            43

   IDMS-CONNECT (idms)             44

   IDMS-DISCONNECT (idms)          45

   IDMS-IF (idms)                  46

   IDMS-RETURN (idms)              47

   IF                              48

   IFX                             50

   KEEP (idms)                     51

   LOADSRC                         52

        MASKAND                         53

   MASKOR                          54

   MODIFY (idms)                   55

   MOVE                            56

   MOVEN                           xx

   MOVEX                           57

   MULTIPLE                        xx

   OBTAIN (idms)                   58

   PACK                            61

   PERFORM                         62

   PRINT                           63

   READ                            64

   READLIB                         65

   READPAN                         66

   READPDS                         67

   READY (idms)                    68

   RESTART                         69

   RETURN                          70

   ROLLBACK (idms)                 71

   SCAN                            72

   SCANSTEP                        73

   SCANTEST                        74

   SPELL                           75

   STORE (idms)                    76

   STRING                          77

   SUBTRACT                        78

   SYNC                            79

   UNPACK                          80

   UNSTRING                        81

   WRITE                           82

   WRITEPDS                        83

   XREF                            84

   XREFDSN                         85

SAMPLES SECTION D

1 COPY FILE                                 4

2 COPY & REBLOCK                            5

3 COPY & CHANGE RECORD SIZE                 6

4 COPY MULTIPLE FILES                       7

5 COPY & CHANGE RECORD FORMAT VB TO FB      8

6 COPY & CHANGE RECORD FORMAT FB TO VB      9

7 COPY ONLY SELECTED RECORDS                10

8 COPY & REMOVE SELECTED RECORDS            11

9 COPY & REMOVE SELECTED RECORDS            12

10 COPY & MODIFY DATA IN RECORDS            13

11 COPY & MODIFY DATA IN SELECTED RECORDS   14

12 COPY WITH LIMIT COUNT                    15

13 PRINT A FILE                             16

14 RECORD VERTICAL DUMP                     17

15 RECORD HORIZONTAL DUMP                   18

16 SELECTIVELY PRINT, DUMP, & COPY FILES    19

17 COMPARE TEST FILES BEFORE & AFTER        20

18 SYNC FILES TO GET MATCHING TEST DATA     21

19 SYNC FILES FOR MERGE                     22

20 SYNC FILES TO MODIFY DATA                23

21 SYNC FILES TO REMOVE UNMATCHED RECORDS   24

22 SYNC FILES TO PRINT MATCHED SETS         25

23 SYNC FILES TO COMPARE RECORDS            26

24 GENERATE TEST DATA                       27

25 GENERATE CONTROL CARDS FROM A REPORT     28

26 SCAN RECORDS FOR VALUES IN ANY POSITION 29

27 SCAN/REPLACE DATA ON FILE                30

28 SCAN PROCLIB FOR A PROGRAM               31

29 SCAN/REPLACE TEST DATA PDS LIBRARY       32

30 CROSS REFERENCE AN APPLICATION           33

31 CONVERT NUMERIC BINARY TO CHARACTER      34

32 READ AND REMOVE DUPLICATE RECORDS        35

33 ADD FIELDS INTO THE CENTER OF A RECORD   36

34 SYNC MASTER & PATCH FILE TO MODIFY REC   37

35 COMPARE MST REC FOR THOSE ON A CTL LIST 38

36 COMPARE BUT EXCLUDE DATE FIELD           39

37 COMPARE SELECTED FIELDS                  40

38 COMPARE QUANTITY HISTORY TRACE           41

39 PRT ALL REFERENCES TO A FILE & ITS PGM   42

40 SCAN PROCLIB & PRINT PGM WITH ITS PROC   43

41 READ SEQ FILE & CREATE A PDS FILE        44

42 MERGE ALL MEMBERS TO A SINGLE MEMBER     45

43 INSERT A /*ROUTE CARD IN EACH MEMBER     46

44 DELETE A /*ROUTE CARD IN EACH MEMBER     47

45 MASS JCL SCAN                            48

46 COMPARE CONTROL CARD LIBS                49

47 SEND JCL TO PRINTER WITH PAGE EJECTS     50

48 DISPLAY ADDRESS TEXT                     51

49 CHECK SPELLING ON TEXT FILE              52

50 SOURCE CODE COMPARE                      53

51 LIBRARY SOURCE CODE COMPARE              54

52 MASS COMPILE PROCESSING                  56

53 CALL USER MODULES FOR PROCESSING         57

54 RESET NUMERIC FIELDS                     58

55 TALLY NUMERIC FIELDS                     59

56 CONVERT NUMERIC FIELDS                   60

57 IMS DATA BASE ACCESS                     61

58 CROSS REFERENCE ON PANVALET              63

59 SCAN LIBRARIAN FILE FOR VALUES           64

60 SCAN/REPLACE DATA ON FILE                65

61 BUILD A SYSTEM DATASET CROSS REFERENCE   66

62 MASTER FILE WITH VARIABLE TRAILERS       67

63 COPY ONLY SELECTED RECORDS               68

64 ENCRYPT SOURCE CODE FOR SECURITY         69

65 DECODE SAMPLE 64                         70

66 ENCODE AN INDIVIDUAL FIELD               71

67 FB TO A COMPUTED VB FILE                 72

68 COMPRESS A FILE                          73

69 DECOMPRESS A FILE                        74

70 STRING MEMBER NAMES                      75

71 UNSTRING NAME, ADDRESS, CITY             76

72 IDMS ADS/O SOURCE CODE SCAN              77

73 IDMS RECORD AREA SWEEP PRINTS            78

74 IDMS ADS/O LOAD, MAP, GEN PRINT          80

75 DB2 TABLE EXTRACT AND PRINT              82

76 DB2 EXTRACT AND DELETE SELECTED ROWS     83

77 DB2 EXTRACT, UPDATE, AND COMPARE         84

78 IMS DL1 DATABASE PRINT DUMP              85

79 DB2 PARTIAL TABLE DELETE AND RELOAD      86

80 CONVERT IDMS TO DB2 ROWS                 87

81 SYNC PATCH FILE TO MASS UPDATE DB2 ROWS 89

82 PATCH CA-DATACOM DATABASE & COMPARE      90

83 LIST IMS SEGMENTS WITH BAD DATES         93

84 IMS TO DB2 DATA BASE TRANSFER            95

85 LOAD CA-DATACOM TO A DB2 DATA BASE       96

86 DYNAMIC FILE CREATION FROM A LIST        98

87 DYNAMIC FILE FROM TRANSACTIONS          100

88 SYNC TO MODIFY ONE-TO-MANY CASE         102

ERROR MESSAGES SECTION E

TUTORIAL SECTION F

LESSON 1 - GETTING STARTED              2

LESSON 2 - FILE RECORD PRINTS           4

LESSON 3 - MODIFYING RECORDS            6

LESSON 4 - FILE MOD FROM ANOTHER FILE   8

LESSON 5 - FILE SYNCHRONIZED            10

LESSON 6 - FILE SCANNING                14

LESSON 7 - LIBRARY PROCESSING           16

LESSON 8 - XREF SOURCE CODE             19

LESSON 9 - FILE COMPARES                20

LESSON 10- SYNC COMPARES                21

LESSON 11- LIBRARY COMPARES             22

LESSON 12- FORMATTING SPECIAL REQUESTS 24

INSTALLATION GUIDE SECTION G

SAMPLE RUNS SECTION H

COMMAND CROSS REFERENCE

ACCEPT see cmd section (idms)

ADD 53,55,57,62,64,65,72,74,77,78

BIND 72,73,74,80

CALL 53,57,66,78,82,83,84,85

COMPSRC 51

COMMENTS (all samples)

COMMIT see cmd section (idms)

COMPARE 17,23,35,36,37,38,46,77

COMPRESS 68

CVTBIN 56,62,64,65,80,82

CVTDEC 56,72,77

CVTCHAR 31,56,74

DB2-CONNECT 75,76,77,79,81,84,85

DECODE 65,66

DEFAREA 72,73,74,75,76,77,78,79,80,

81,82,83,84,85

DEFINES (all samples)

DECOMPRESS 69

DB2-DISCONNECT 75,76,77,79,81,84,85

DELETE 8,20,30,44,46,58

DIVIDE 55

DLILINK 57,78,83,84

DUMP 14,73,78,81

ERASE see cmd section (idms)

EXHIBIT 48,53,55,57,71,72.73,75,77,80,81,82,86,87

EXEC SQL .... END-EXEC 75,76,77,79,80,81,84,85

FIND 72,74

FINISH 72,73,84,80

GET see cmd section (idms)

IDMS-CONNECT see cmd section

IDMS-DISCONNECTsee cmd section

IDMS-IF see cmd section

IDMS-RETURN see cmd section

IF 7,8,9,11,12,13,14,15,16,18,20,21,

24,27,30,32,34,35,37,39,40,41,43,44,

45,46,47,51,52,53,54,55,57,58,60,62,

69,78,80

IFX 63

GOTO (all samples)

LOADSRC 50,51,

KEEP see cmd section (idms)

MASKAND 53

MASKOR 56

MODIFY see cmd section (idms)

MOVE 5,6,10,11,20,24,25,27,29,32,33,34,

36,37,38,39,40,41,42,43,45,47,51,54,

60,62,64,65,67,70,72,80

MOVEN 56

MOVEX 72,73,74,80

MULTIPLY 55

PACK 56

PERFORM 7,37,46,62,72,82

PRINT 7,13,16,22,27,29,39,60,72,73,79

READ 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,

16,17,25,26,27,31,32,33,41,48,52,54,

55,56,62,63,66,67,68,69,70,71,76,79

READLIB 59

READPAN 58

READPDS 28,29,30,39,40,42,43,44,45,46,47,49,

50,51,61,64,65

READY 72,73,74,80

RESTART 52

RETURN 7,37,46,62,72,82

ROLLBACK see cmd section (idms)

SCAN 26,28,59,72

SCANTEST 27,29,39,40,41,43,44,45,52,60,67

SCANSTEP 60,70,71

SPELL 49

STORE see cmd section (idms)

STRING 70

SUBTRACT 55,65

SYNC 18,19,20,21,22,23,34,35,36,37,38,

81,88

UNPACK 56

UNSTRING 71

WRITE 1,2,3,4,5,6,7,8,9,10,11,12,16,18,

19,20,21,24,25,27,31,32,33,34,

40,45,47,52,53,54,55,56,57,60,62,

63,66,67,68,69,70,75,77,78

WRITEPDS 29,41,42,43,44,64,65

XREF 30,58

XREFDSN 61

TOPIC CROSS REFERENCE (partial highlights)

ANALYSIS IDEAS 23,28,58,72,74

CODING IDEAS 52,58

TESTING IDEAS 16,18,23,68,69

AUDITING IDEAS 55,65,66,74

DOCUMENTATION IDEA 49

PROCESS CONTROL 1,4,7,23,55

FILE ACCESS 1,18,29,58,59

DATA BASE ACCESS 57,73,75,78,82,83,84,85

DATA MANIPULATION 6,31,53,56

FILE COPIES 1,2

FILE SQUEEZE 68,69

DATA ENCRYPTION 64,65,66

FILE PRINTS/DUMPS 14,15,16,72,73

SOURCE CODE COMPARES 50,51

FILE COMPARES 17,23,35

DATA ELEMENT CROSS REF 30,58,72,74

DATASET CROSS REFERENCE 30

JCL TOOLS 28,45,52

COMPILE AIDS 52,73,74

TEST FILE CREATION 16,20,24

CONVERSION AIDS 56

TALLY/AUDIT COUNTS 55

QUICK REPORTS 40,47

RESERVED VARIABLES

COUNTIN 12,13,14,15

COUNTOUT 24

COUNTDEL see cmd section

EPILOGUE 55,76,77,79,81,84,85

EOJ 18,62

IDMS-CTRL see cmd section

IDMS-DBKEY see cmd section

IDMS-RECNUM see cmd section

IDMS-STATUS 72,73,74,80

LOC 27,29,60,62

MEMNAME 30,40,41

SCANHIT 27,29,39,43

SQL-REASON see cmd section

SQLCODE 75,76,77,79,80

SQLCOUNT 79

RECORDSW 46,52

RETURN-CODE 53

VAR 62

***See individual command explanations in section II.

PREFACE

This publication provides the syntax and a brief descriptionof the functions and commands used in the Workbench(tm) Programmer ProductivityAid utility. It is intended as a reference and teaching guide for all users.Prior knowledge of IBM OS/MVS is assumed.

We suggest that first time users of Workbench(tm) browse the Tutorial Lessons(Section F ) before reviewing the command syntax. Numerous samples are given inthe sample section to cover the common uses. A topic & command crossreference is provided to locate usage in the samples. Your comments andsuggestions are welcome. Please write to the address at the beginning of thismanual.