|
Data-Miner is an easy to use,
general purpose VSAM I/O interface utility designed to
simplify and standardize access to VSAM files. Data-Miner
provides full VSAM access from programs written in many
fourth generation languages (4GL) such as NATURAL and
Focus. Data-Miner also provides a more powerful, easier
and more efficient way of accessing VSAM from programs
written in third generation languages such as COBOL and
PL/I.
• Data-Miner is a standardized
VSAM interface. Data-Miner
simplifies and standardizes VSAM access procedures for all
languages, provides consistent VSAM access across
applications and processing environments, and reduces
VSAM training requirements for your programming staff.
• No VSAM expertise is needed to use
VSAM files. Data-Miner is based on the
premise that VSAM users should be able to use VSAM without
extensive VSAM training.
• Data-Miner increases
VSAM functionality. Data-Miner
adds additional VSAM commands and functions to programs
accessing VSAM while simplifying VSAM coding.
• Data-Miner
improves programmer VSAM productivity. Data-Miner
permits programmers to easily access VSAM files
from any program written in any language, (including
COBOL, PL/I, NATURAL, Assembler and most 4GLs).
• Data-Miner
enhances your programmers' VSAM proficiency. Data-Miner
reduces the frequency of VSAM programming errors,
simplifies VSAM request processing and provides
consistent VSAM error code analysis and handling.
Data-Miner ensures that correct VSAM command protocol
is implemented.
• Data-Miner
makes COBOL and PL/I easier to use and
manages all the complexities involved with accessing
VSAM files.
Inexperienced and proficient programmers alike
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.
Support
Data-Miner/Online is
an online VSAM editing system designed to be used by
programmers 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 knowledge of Command
Level syntax or VSAM commands. PF keys are available
for most screen functions.
Data-Miner/SAM/VSAM is
a file access tool designed for use by operations
and programming personnel to selectively search and
retrieve records by record key, record location or
record content. All SAM and VSAM files are supported.
Records can be changed, copied, extracted, dumped
or printed with just a few commands. Simple
reports and lists can be produced in minutes. File
conversions and mass data changes can be accomplished
quickly and accurately.
CICS Editor
Data-Miner’s Online CICS
Editor accesses VSAM files without programming of any
type. Up to 500 records at a time may be retrieved.
These records are held in Temporary Storage for the
duration of the transaction where they may be quickly
browsed, deleted and modified.
Data-Miner/SAM/VSAM
Data-Miner/SAM/VSAM is a high
performance software utility package, which permits
quick, easy access to SAM and VSAM files for selective
searching, printing, extracting, updating, dumping
and copying of file data without programming.
Data-Miner/SAM/VSAM is valuable
both in production and development environments. It
consolidates utility functions associated with file
searches, data manipulation and report generation into
one easy-to-use product.
Data-Miner/SAM/VSAM reduces
the costs associated with having to learn and use many
complex and unrelated utilities by giving you one simple
product to accomplish most of your day-to-day data
handling and reporting tasks.
Data-Miner/SAM/VSAM can copy,
dump or print all or part of a dataset. It can extract
parts of records and update records in place. Both
sequential files and VSAM files
are supported for both input and output. All three
types of VSAM files - KSDS, ESDS & RRDS - are supported. Data-Miner/SAM/VSAM can
selectively retrieve records by full key, generic key, relative record number
or record number. Data-Miner/SAM/VSAM accesses a VSAM file's catalog to establish
if it is KSDS, RRDS, or ESDS.
Powerful record selection
parameters can be used to retrieve specific records
or groups of records on the basis of physical position in the file, the contents
of one or more fields or a combination of both. For example, the first 1000
records with a negative balance could be selected from
a file to create a test data file. All selection arguments
can be logically "ANDed" and "ORed" to
allow complex selection criteria.
Once records have been selected,
Data-Miner/SAM/VSAM can perform extensive modification
on the selected records. The modification process can be performed on all or
part of the selected records.
Data-Miner/SAM/VSAM can change
file organization, recording medium, block size, record
length or record content while copying data to a new
dataset.
Data-Miner/SAM/VSAM, in addition
to its powerful copy functions, can perform extensive
print functions. The PRINT function produces a formatted
report of selected fields from the input file. The
DUMP function produces a character/hex dump of the
input file. Either option can be modified to produce
a formatted report with headers, formatted data elements,
literals and accumulated counts and totals. Reports
can be configured for hard copy printing or for viewing
on a CRT.
Data-Miner/SAM/VSAM Example
This example produces a formatted
list of certain business accounts. A report of account
numbers, social security numbers and amounts is to
be printed from INFILE. Selection starts at record
number 200. Account numbers equal to 3333 are skipped.
Amounts over $3,000 or less than 0 are flagged. The
heading is changed except for DATE and PAGE NO. A blank
line indicates a break in account numbers. Only the
first 5000 records are required. A total of the amounts
printed on the report are to be accumulated and printed
with a floating dollar sign at the end of the list.
Lines starting with an asterisk are comments.
Parameters
INPUT=DISK
FIXED LRECL=300 BLKSIZE=3000
BGNFIELDS
ACCT_NO 1,4,C
AMOUNT 60,6,P,2
FLAG 100,3,C
ENDFIELDS
DEFINE TOT_AMT 100,3,C
First=200
SKIP ACCT_NO = '3333'
add amount to tot_amt
if amount > 3000 or amount <0
move "***" to flag
endif
if acct_no ne prev
space
endif
MAXRCDS=5000
SELECT * FROM INFILE
TOT 'TOTAL PAY IS',1 TOT_AMT,17,9
Sample Print
ACCT_NO SOC-SEC-NO AMOUNT FLAG
DATE 1-7-2005 PAGE 1
1234 501-30-1433 7,775.25 ***
1234 502-30-1456 2,495.33
2345 123-12-4567 -1,995.43 ***
2345 501-30-1433 6,001.15 ***
3987 601-30-1234 4,999.99 ***
TOTAL PAY IS $19,276.29
The 4GL Connection
Data-Miner allows 4GL users
to read and write VSAM files.
Many fourth generation languages (4GL) will only read
VSAM. Only a few will allow users to both read and write
VSAM. Over 100 users of Software AG's fourth generation
language (NATURAL) have used Data-Miner 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
altogether) unneeded conversion of VSAM files to DBMS, allowing users to easily
handle VSAM files that they don't wish to migrate to the DBMS.
The COBOL Connection
In addition to providing VSAM
access from languages that do not have native access
to VSAM, Data-Miner also provides easy VSAM access
from languages that do have native access to VSAM such
as COBOL and PL/I.
Data-Miner makes VSAM access
easier and more flexible in COBOL and PL/I programs.
Data-Miner offers an extremely
simple syntax using standard program calls. COBOL and
PL/I users no longer have to concern themselves with
complex VSAM protocol or with knowing anything VSAM.
In addition to being simpler
to use, Data-Miner allows users to perform operations
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 makes COBOL/VSAM
access faster and more efficient.
VSAM Access Options
Data-Miner provides a common
interface into your VSAM files, whether that access
originates within CICS or from any concurrently executing
program(s) written in any language and running online
or in batch mode.
Online Access
Application programs can access
VSAM files and CICS temporary storage queues through
a standard program CALL with associated parameter values.
All programming languages that can call Assembler sub-routines
are supported.
Batch Access
Data-Miner supports VSAM access
for batch environments. All programming languages that
can call assembler sub-routines are supported. The
batch facilities provide easy access to VSAM files
from any program written in any language and executed
in batch mode. Batch programs access VSAM files through
a standard program CALL with a single parameter that
is identical no matter what function is being performed.
|
