150 likes | 307 Views
Quick programming tool for SAM, VSAM & DB2 Detailed report writer Ad hoc reports File extracts On-line view & edit of CICS files & temp storage VSAM I/O driver module for user programs Multi-lingual. DataMiner 7.0. placeholder. Report writer. The report. Ad hoc reports.
E N D
Quick programming tool for SAM, VSAM & DB2 Detailed report writer Ad hoc reports File extracts On-line view & edit of CICS files & temp storage VSAM I/O driver module for user programs Multi-lingual DataMiner 7.0 placeholder
Ad hoc reports • Automatic layout • Totalling & other calculations • Selected records • Key • Number of records • Field value • Comparison with previous records / running totals / work fields
Ad hoc report SCRIPT • KEY 1 8 C • AMOUNT 60 11 P 2 • PRINT • SELECT *
Record selection IF BALANCE < .01 BALANCE = 0 ELSE MULTIPLY BALANCE BY 1.02 ENDIF SKIP AMOUNT < 0 ONLY NAME = “HUGGINS” FIRST =20 LAST=200
Data-Miner also speaks… • SQL • SELECT (*) FROM PAYROLL WHERE SALARY > 100000
Data-Miner also speaks… • CA/Easytrieve • EXEC Data-Miner with your Easytrieve commands • Runs unmodified • Produces same output • Mix Data-Miner and Easytrieve commands in the same job • Mix DM & EZT parameters in the same command
Data-Miner also speaks… • German • Even better than John Rankin! • Long command names • Could speak any language • Can mix German & English
CICS Access • Read / write CICS VSAM files • Read / write temp storage queues • Updates are queued until you are ready
VSAM Access module • Works in CICS & batch • COBOL, Assembler, PL/I, Natural, anything that can CALL • Functions include • FST,LST,NXT,PRV,GET • GGE,GEQ, • PRV,ADD,DEL,CLS • GTU,GEU,GGU,REL,RPL • No need to worry about wrong ACB /RPL OPTIONS!!
Data-Miner Summary • Make VSAM easy to use • Simple upgrade from Easytrieve • Ad hoc reporting • Easy to upgrade from Easytrieve • File maintenance / copying / extracting • Get rid of Easytrieve • One-off or production work • File fixing • Easy to learn
And did I mention…. • It is dead easy to upgrade to Data-Miner from Easytrieve.