Data-Miner
Data-Miner is a high performance software tool for VSE and z/OS. It provides easy access to SAM & VSAM files and DB2 tables for selective searching, printing, extracting, updating, dumping and copying of file data.
Data-Miner is valuable in both production and development environments. It replaces multiple utilities and gives you one simple product to accomplish most of your day-to-day data handling and reporting tasks, saving you time and licensing costs.
Data-Miner Downloads & Documentation
Data-Miner's Major Functions
Data-Miner is useful for a huge number of tasks that need to be done quickly without any great programming skills being needed.
They include:
COPY one file to another
DELETE or INSERT records in a file
UPDATE records in a file
EXTRACT parts of records into a new file
PRINT a report from a file (automatically formatted or user-formatted)
DUMP a file or selected records to the printer
SHOW selected fields on the printer
Record selection
Any of Data-Miner's functions can be limited to a group of records with simple selection commands such as:
LAST=1000 - to stop after 1000 records have been read
ONLY BALANCE>0 - to select only records with a positive balance
SKIP NAME='JONES' AND CITY='LONDON' - to skip records you aren't interested in
Modifying records
Data-Miner can change the contents of records before they get written. For example, you can say:
BALANCE=BALANCE + SALE or
AMOUNT=0 or
NAME="xxxxxx" or
MOVE 123 TO TOTAL
Writing records
Records can be written to a new file, inserted into an existing file, or updated. Data-Miner can change file organization, recording medium, block size, record length or record content while copying data to a new dataset. So, for example, it is easy to create a KSDS from a sequential file.
Printing records
Data-Miner offers two ways to print a report. It has a simple PRINT command and a more powerful report writer. The PRINT command produces a formatted report that Data-Miner lays out for you. Records can be selected or skipped when printing so that you get a report of just the data you want. For example, this script produces a report of the people who owe more than $1,000:
PRINT INPUT=VSAM FILENAME=ACCOUNTS
* The next line includes our record layout for this file
INCLUDE ACCREC
ONLY BALANCE>1000
SELECT ACCTNO NAME BALANCE
That's all there is to it.
Detailed Report writer
When a more "industrial strength" report is required, the Data-Miner report writer is up to the job. It can sort the report into any order you like, summarize fields, do control breaks and print totals. You also have more control about where fields appear on the print line. A typical report layout looks something like:
REPORT ACCSTAT
ORDER LNM FNM
BREAK LNM
SUM BAL
LINE LNM FNM KEY BAL TALLY
TITLE 'ACCOUNT STATUS REPORT'
Mailing labels
The report writer is equally at home producing mailing labels. Just tell it how big the labels are, what information you want on them and how many there are across the page and it will print them for you.
REPORT ADDRLAB LABELS ACROSS 3 WIDTH 40 HEIGHT 5
LINE 1 INIT LNM LINE 2 ADDR
LINE 3 CITY LINE 4 STATE ZIP
Dumping a file
Intended mainly for programmers, the DUMP function produces a character/hex dump of the input file or the output file or selected records from them. The SHOW command does the same for individual fields and records.
We want to create a test file containing all the records from a production file with negative balances. Our auditors want us to hide the names and addresses in the records. We will get the record layout from a COBOL copybook called “ACCTLAY”.
COPY
INPUT=VSAM FILENAME=ACCOUNT
OUTPUT=VSAM FILENAME=TESTFLE
WHERE BALANCE<0
COPY ACCTLAY
CLOAK NAME ADDRESS
We want to create a sequential disk file containing certain fields from our STAFF database for records where the salary is less than $50,000. Note that we are using SQL to select the records we want - we could also have asked Data-Miner to do it. We also want a report sorted by department & name with departmental totals.
EXTRACT
INPUT=SQL (SELECT NAME, SALARY, DEPT , JOB-TITLE FROM STAFF
WHERE SALARY < 50000)
OUTPUT=DISK FILENAME=LOWPAY LRECL=100 BLKSIZE=4000 FIXED
OUTPUT=PRINTER FILENAME=MAINP
SELECT *
PRINT REPORT-001
REPORT REPORT-001 PRINTER MAINP
ORDER DEPT, NAME
BREAK DEPT
SUM SALARY
LINE DEPT NAME SALARY JOB-TITLE
TITLE “DEPARTMENTAL SALARY REPORT”
Besides its own simple language, Data-Miner also understands Easytrieve and German. This means you can take your existing Easytrieve programs and run them unmodified with Data-Miner. Or users who are used to Easytrieve can include Easytrieve commands and parameters in their Data-Miner jobs.
Data-Miner/VE is an easy to use, general purpose VSAM module that simplifies and standardizes access to VSAM files. It works with any language that can call an assembler routine including fourth generation languages (4GL) such as NATURAL and Focus. Data-Miner/VE also provides a more efficient way of accessing VSAM from programs written in COBOL and PL/I.
Data-Miner/VE provides consistent VSAM access across applications and processing environments, and reduces VSAM training needs for your programming staff. VSAM expertise is no longer required to access VSAM files!
Data-Miner/VE also:
Lets you add new VSAM capabilities to your programs while simplifying VSAM coding.
Improves programmer VSAM productivity - access VSAM files from any program in any language (including COBOL, PL/I, NATURAL, Assembler and most 4GLs).
Enhances your programmers' VSAM proficiency. Data-Miner/VE reduces the frequency of VSAM programming errors, simplifies VSAM request processing and makes VSAM error . Data-Miner/VE ensures that correct VSAM commands are always issued even if the programmer doesn't specifically request them.
Makes VSAM easier to use from COBOL and PL/I. Programmers are freed from considering most technical aspects of using VSAM. Programmers need to know fewer commands and handle fewer errors when they access their VSAM files with Data-Miner/VE.
Data-Miner/VE gives 4GL users the ability to read and write VSAM files. Over 100 users of Software AG's NATURAL language have used Data-Miner/VE to access VSAM files with full power and exceptional reliability. Users can bring all the power and productivity of their 4GL programming language to the VSAM world, making VSAM a full partner to their Data Base Management System (DBMS).
The Data-Miner and 4GL partnership optimizes development efforts by:
Requiring only one programming language for all application development and increasing programmer productivity by 10:1 over COBOL and PL/I;
Coupling the productivity of your 4GL with the efficiency of VSAM and permitting users to quickly satisfy report requests and requests for VSAM information;
Accessing VSAM and DBMS files at the same time in the same program, eliminating the need to maintain redundant copies of VSAM files in your DBMS;
Delaying or avoiding conversion of VSAM files to DBMS, allowing users to easily handle VSAM files that they don't wish to migrate to the DBMS.
In addition to providing VSAM access from languages that do not have native access to VSAM, Data-Miner/VE also provides simpler VSAM access from languages such as COBOL, PL/I and Assembler. Data-Miner/VE makes VSAM access easier and more flexible in COBOL and PL/I programs. Data-Miner/VE offers an extremely simple syntax using standard program calls. Programmers no longer have to know anything about VSAM and its complex protocols.
Data-Miner/VE also lets users do things that are either difficult in COBOL or totally impossible. Some of these functions include: automatic loading to empty files, backward browsing in the middle of a file, reset to empty on the fly and automatic retrieval of record lengths for variable length records. Data-Miner/VE makes COBOL/VSAM access faster and more efficient.
Data-Miner/VE works both for CICS programs, too, bringing new simplicity to the job of the online transaction programmer.
Application programs can access VSAM files and CICS temporary storage queues through a standard program CALL and a single parameter. All programming languages that can call Assembler sub-routines are supported.
Data-Miner/Online is an online VSAM editing system that programmers use as a development and testing aid. All VSAM and temporary storage read/write functions are supported under CICS. Records can be displayed in either alphanumeric or hexadecimal format. Records can be read by key, browsed, added, updated and deleted without any programming knowledge needed.
ISPF editor
Under z/OS, the Data-Miner ISPF editor lets programmers browse and edit any dataset that they have access to. Editing can be done in character, hex or both making it an ideal tool for incorporating test conditions into datasets quickly.
Network
Management & MonitoringSecurity Management
Data Management
Systems Management
Online Management
VSAM Management
Storage Management
