EXPRESS SORTWARE
A facility to sort/copy/merge and perform other typical ad hoc operations on VSAM, QSAM (flat) files
with zero-programming, zero-JCL, and zero-syntax knowledge.
SORTWA EXPRESS SORTWARE MAIN MENU 09/20/07 22:21
OPTION : 11 RUN TYPE : f (B)ACK/(F)OREGROUND. Default is "B".
LIST OF OPTIONS:
1. SORT/COPY
2. SUMMARIZATION BY GROUPS
3. SORT-MERGE
4. FILE MATCHING
5. STATISTICS (COUNT, MINIMUM, MAXIMUM, AVERAGE, TOTAL)
6. VERIFY (EXAMINATION OF NUMERIC FIELDS FOR INVALID VALUES)
7. UNIQUE VALUES (COUNTS OF UNIQUE VALUES IN SPECIFIED FIELDS)
8. SPLIT/MULTIPLY DATASET
9. DUPLICATE MANAGEMENT
10. SET RETURN CODE BASED ON RECORD COUNT
11. REPORTER
12. SETUP
Pressing the ENTER key on each panel of this menu serves as EXECUTE.
COPYRIGHT (C) 2002 SAKMAN SOFTWARE CORPORATION
F1=HELP F3=EXIT F4=SAVE AS DEFAULT
1.EXPRESS SORTWARE SORT/COPY
|
SORT/COPY is a typical SORT function whereby an input dataset is taken, and an output dataset is produced. The
attributes of the
input dataset is
used as the
attributes of the
output dataset. If a key(s) is specified, the output dataset is ordered by that key. If selection criteria are specified (thru PF6), records satisfying the criteria are INCLUDEd or EXCLUDEd. Reformatting of the records may be specified thru PF7 |
EXSOCO EXPRESS SORTWARE SORT/COPY 09/20/07 22:21
INPUT DATASET : PJ3.SYSWK.CG1.CG711611.WPACTV.D0807
OUTPUT DATASET: PJ3.SYSWK.CG1.CG711611.WPACTV.D0807.PS2B
START AT INPUT RECORD NUMBER: 1 OPTIONAL
STOP AT INPUT RECORD NUMBER : 301 OPTIONAL
F1=HELP F3=EXIT F4=SAVE AS DEFAULT F5=ED IN/PRM/OU F6=CRI F7=RFMT F8=SRT KEY
Function key F6 calls selection criteria panel
Function key F7 calls reformat panel
Function key F8 calls sort keys panel
2. SUMMARIZATION BY GROUPS
|
SUMMARIZATION BY GROUPS takes in the INPUT DATASET, groups the records by the SORT KEY (PF8), and summarizes the values of the fields in the groups as defined thru PF7, and presents these fields in the OUTPUT DATASET as formatted thru the specifications defined thru PF7 If selection criteria are specified (thru PF6), records satisfying the criteria are INCLUDEd or EXCLUDEd. |
EXSUMM EXPRESS SORTWARE SUMMARIZATION BY GROUPS 09/20/07 22:25
INPUT DATASET : PJ3.PRIV.PRINTPDS.ps1
OUTPUT DATASET: PJ3.PRIV.PRINTPDS.newps.s3
START AT INPUT RECORD NUMBER: 1 OPTIONAL
STOP AT INPUT RECORD NUMBER : 99999999 OPTIONAL
F1=HELP F3=EXIT F4=SAVE AS DEFAULT F5=ED IN/PRM/OU F6=CRI F7=SUMM F8=SRT KEY
Function key F6 calls selection criteria panel
Function key F7 calls reformat panel for the layout of summarized fields,
after which the fields specification panel will be called for the positions of the summary fields
Function key F8 calls sort keys panel
3. SORT-MERGE
|
SORT-MERGE
takes in all
INPUT DATASETS
and merges them
in the key order
into OUTPUT
DATASET. MERGE process runs with "OPTION EQUALS" control, which means that the order of output records with equal control fields is to be based on the file number of the input data sets and the original order of the records within each input data set |
EXSOME EXPRESS SORTWARE SORT-MERGE 09/20/07 22:27
INPUT DATASETS: PJ3.PRIV.PRINTPDS(PEGAPUL1)
PJ3.PRIV.PRINTPDS(PEGAPUL2)
______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
OUTPUT DATASET: PJ3.PRIV.PRINTPDS.newpsx
F1=HELP F3=EXIT F4=SAVE AS DEFAULT F5=ED INP F6=ED OUT F7=ED PARM F8=MRG KEY
Function key F5 calls ISPF edit on the INPUT DATASETS
Function key F6 calls ISPF edit on the OUTPUT DATASET
Function key F7 calls ISPF edit on the parameters created
Function key F8 calls sort keys panel
4. FILE MATCHING
|
FILE MATCHING lets 2 datasets to be compared based on a key. Non-matching records from INPUT DATASET #1 is placed into: &SYSUID..NONMTCH1. Non-matching records from INPUT DATASET #2 is placed into: &SYSUID..NONMTCH2. Matching records from both INPUT DATASETS is placed into: &SYSUID..MATCHING. Datasets may be of differing record lengths, however the position of the key field(s) must be in the same positions on each file. If a key field has duplicates in a dataset, only one of the records of the duplicate-key group is processed. |
EXMATC EXPRESS SORTWARE FILE MATCHING 09/20/07 22:28
INPUT DATASET #1: PJ3.TEMP3
INPUT DATASET #2: PJ3.TEMP4
Non-matching records from INPUT DATASET #1 will be put into: &SYSUID..NONMTCH1
Non-matching records from INPUT DATASET #2 will be put into: &SYSUID..NONMTCH2
Matching records from both INPUT DATASETS will be put into : &SYSUID..MATCHING
F1=HELP F3=EXIT F4=SAVE AS DEFAULT F5=ED INPUT F6=ED OUTPUT F8=MATCHING KEYS
Function key F5 calls ISPF edit on the INPUT DATASETS
Function key F6 calls ISPF edit on the OUTPUT DATASET
Function key F8 calls the fields panel to specify the match keys
5. STATISTICS (COUNT, MINIMUM, MAXIMUM, AVERAGE, TOTAL)
| STATISTICS
produces a report
(TOOLMSG) where
the following
calculated fields
are displayed: 1. The COUNT of the selected INPUT DATASET records 2. MINIMUM, MAXIMUM, AVERAGE, and TOTAL values of the numeric fields as defined thru PF8. If selection criteria are specified (thru PF6), records satisfying the criteria are INCLUDEd or EXCLUDEd. |
EXSTAT EXPRESS SORTWARE STATISTICS 09/20/07 22:28
INPUT DATASET : PJ3.PRIV.SOURCE(TESTSTAT)
DATASET RECORD COUNT; AND MINIMUM, MAXIMUM, AVERAGE, TOTAL will be created
for each field defined by pressing F8.
F1=HELP F3=EXIT F4=SAVE AS DEFAULT F5=ED INP F6=CRIT F7=ED OUT F8=STAT FLDS
Function key F5 calls ISPF edit on the INPUT DATASETS
Function key F6 calls selection criteria panel
Function key F7 calls ISPF edit on the OUTPUT DATASET
Function key F8 calls the fields panel to specify the fields upon which statistics are to be gathered
6. VERIFY (EXAMINATION OF NUMERIC FIELDS FOR INVALID VALUES)
|
VERIFY produces a report (TOOLMSG) where the following fields are displayed: 1. The COUNT of the selected INPUT DATASET records 2. Invalid values in the numeric fields as defined thru PF8. If the "IGNORE THE SIGN FIELD" is "Y", the invalid value in the sign portion of the sign byte is ignored. If selection criteria are specified (thru PF6), records satisfying the criteria are INCLUDEd or EXCLUDEd. |
EXVERI EXPRESS SORTWARE VERIFY 09/20/07 22:29
INPUT DATASET : PJ3.PRIV.SOURCE(TESTVERI)
IGNORE THE SIGN FIELD: N (N)O OR (Y)ES. DEFAULT IS "N".
Each field, defined by pressing F8, will be inspected for invalid values.
F1=HELP F3=EXIT F4=SAVE AS DEFAULT F5=ED INP F6=CRIT F7=ED OUT F8=VERIFY FLD
Function key F5 calls ISPF edit on the INPUT DATASETS
Function key F6 calls selection criteria panel
Function key F7 calls ISPF edit on the OUTPUT DATASET
Function key F8 calls the fields panel to specify the fields upon which verification to be performed
7. UNIQUE VALUES (COUNTS OF UNIQUE VALUES IN SPECIFIED FIELDS)
|
UNIQUE VALUES produces a report (TOOLMSG) where the following fields are displayed: 1.
Unique
combination of
the values in
fields as defined
thru PF8. |
EXUNIQ EXPRESS SORTWARE UNIQUE VALUES 09/20/07 22:29
INPUT DATASET : PJ3.PRIV.SOURCE(TESTUNIQ)
The UNIQUE VALUES and their COUNTS will be given for the FIELDS defined
by pressing F8 will be given.
F1=HELP F3=EXIT F4=SAVE AS DEFAULT F5=ED INP F6=CRIT F7=ED OUT F8=UNIQ FLDS
Function key F5 calls ISPF edit on the INPUT DATASETS
Function key F6 calls selection criteria panel
Function key F7 calls ISPF edit on the OUTPUT DATASET
Function key F8 calls the fields panel to specify the fields where unique values are to be determined
8. SPLIT/MULTIPLY DATASET
|
SPLIT/MULTIPLY DATASET is a process whereby an input dataset is taken, and as many output datasets as defined are produced. The attributes of the input dataset is used as the attributes of the output datasets. If a key(s) is specified, the output datasets are ordered by key(s). If selection criteria are specified (thru PF6), for an OUTPUT DATASET, records satisfying the criteria are INCLUDEd or EXCLUDEd in that OUTPUT DATASET; otherwise all records of the INPUT DATASET is transferred. |
EXSPMU EXPRESS SORTWARE SPLIT/MULTIPLY DATASET 09/20/07 22:30
INPUT DATASET : PJ3.PRIV.PRINTPDS.PEGAPULX
OUTPUT DATASET #1 : PJ3.PRIV.PRINTPDS.PEGAPUL1
#2 : PJ3.PRIV.PRINTPDS.PEGAPUL2
#3 : PJ3.PRIV.PRINTPDS.PEGAPUL3
#4 : PJ3.PRIV.PRINTPDS.PEGAPUL4
#5 : PJ3.PRIV.PRINTPDS.PEGAPUL5
#6 : PJ3.PRIV.PRINTPDS.PEGAPUL6
#7 :
#8 :
#9 :
#10:
#11:
#12:
#13:
#14:
#15:
#16:
#17:
#18:
F1=HELP F3=EXIT F4=SAVE AS DEFAULT F5=ED IN/PARM F6=SELECT CRIT F8=SRT KEY
Function key F5 calls ISPF edit on the INPUT DATASET and parameters created
Function key F6 calls selection criteria panel
Function key F8 calls sort keys panel
9. DUPLICATE MANAGEMENT
|
DUPLICATE
MANAGEMENT
is a process
whereby the INPUT
DATASET is
inspected for
duplicate values
in the fields
defined thru PF8,
and two datasets,
containing unique
values and
duplicates are
created: Verification concept: Number of records in &SYSUID..SORTWARE.UNIQUE +Number of records in &SYSUID..SORTWARE.REST = Number of records in INPUT DATASET |
EXDUPS EXPRESS SORTWARE DUPLICATE MANAGEMENT 09/20/07 22:30
INPUT DATASET : PJ3.PRIV.SOURCE(SNGBUSS)
Based on the DUPLICATE FIELDS defined by pressing F8, the following datasets
will be created:
1. &SYSUID..SORTWARE.UNIQUE
(A unique-key subset of INPUT DATASET records, i.e.,
all the ones that are non-duplicates plus the first record of duplicates.)
2. &SYSUID..SORTWARE.REST
(The rest; i.e., a subset of input records whose key values would constitute
a duplicate; i.e., duplicates with the exception the first record of the
duplicate group.)
Verification concept: Number of records in &SYSUID..SORTWARE.UNIQUE +
Number of records in &SYSUID..SORTWARE.REST =
Number of records in INPUT DATASET
F1=HELP F3=EXIT F4=SAVE AS DEFAULT F5=ED INP F7=ED OUT F8=DUPLICATE FIELDS
Function key F5 calls ISPF edit on the INPUT DATASET
Function key F7 calls ISPF edit on the OUTPUT DATASET
Function key F8 calls the fields panel to specify the fields where duplicates are to be detected
10. SET RETURN CODE BASED ON RECORD COUNT
|
SET RETURN CODE BASED ON RECORD COUNT determines the number of records in the INPUT DATASET, compares this number to the number specified, and sets the return code to 4 if the comparison yields true, or to 0 if false. The comparison operator can be: EQ, GT, LT, NEIf selection criteria are specified (thru PF6), records satisfying the criteria are INCLUDEd or EXCLUDEd |
EXRETU EXPRESS SORTWARE SET RETURN CODE BASED ON RECORD COUNT 09/20/07 22:30
INPUT DATASET : PJ3.PRIV.SOURCE(TESTCOUN)
COMPARE OPR NUMBER
----------- --------
IF NUMBER OF RECORDS IN THE INPUT DATASET IS gt 0 ,
THEN SET THE RETURN CODE TO 4, OTHERWISE TO 0.
(The comparison operator can be: EQ, GT, LS, NE)
F1=HELP F3=EXIT F4=SAVE AS DEFAULT F5=EDIT INP F6=SELECT CRIT F7=EDIT OUT
Function key F5 calls ISPF edit on the INPUT DATASET
Function key F6 calls selection criteria panel
Function key F7 calls ISPF edit on the OUTPUT DATASET
11. REPORTER
|
REPORTER takes in the INPUT DATASET, and produces a report with the TITLE, COLUMN HEADERs, detail lines with the specified fields, and, if any fields is defined with a type numeric, a TOTAL line where numeric fields are summed up. If a key(s) is specified, the report is ordered by that key. If selection criteria are specified (thru PF6), records satisfying the criteria are INCLUDEd or EXCLUDEd |
EXREPO EXPRESS SORTWARE REPORTER 09/20/07 22:31
INPUT DATASET : PJ3.PRIV.KSDS
REPORT TITLE: TEST
COLUMN HEADER STARTING POS NUMBER OF COLS TYPE
BALANCE1 20 8 ZD
BALANCE2 30 8 ZD
ACCOUNTNO 40 20 CH
ACCOUNTNAME 63 40 CH
ADDRESS1 104 30 CH
ADDRESS2 140 30 CH
F1=HELP F3=EXIT F4=SAVE AS DEFAULT F5=ED INP F6=CRIT F7=ED OUT F8=SORT KEY
Function key F5 calls ISPF edit on the INPUT DATASET
Function key F6 calls selection criteria panel
Function key F7 calls ISPF edit on the OUTPUT DATASET
Function key F8 calls sort keys panel