Data-Miner version 7.0 for VSE Data-Miner version 7.0 includes all maintenance applicable to version 6. It is distributed as a single zip file which unzips into a single Power job. You should modify this Power job to meet your own installation's requirements such as job class and libraries before submitting it. Alternatively, you can submit it and reply to the PAUSEs that appear on the console. What's new DB2 support The primary input file to Data-Miner can now be specified using an SQL statement to read the required rows one at a time from the database and place field values into Data-Miner work fields. It is not necessary to define those workfields as Data-Miner retrieves the field definitions from the database's dictionary. All field types may be read but, in version 7, not all field types can be used in arithmetic and character calculations. German language All of Data-Miner's main commands (READ, WRITE, IF etc) can now be specified in German. German and English commands can be used in any combination. STOP command The STOP command can also be entered as STOP RUN or STOPRUN HIDE and CLOAK HIDE and CLOAK help you create file extracts that are in the right format but that have sensitive information protected. "HIDE FLDX", for example, replaces FLDX with spaces or zero as is appropriate for the field's type. "CLOAK FLDX" replaces FLDX witha random string of characters or a random number as appropriate. CLOAK does not encrypt a field - its original value cannot be derived from the cloaked value and, if the job is rerun, a different cloaked value will be put into the field. AT EOJ An end of job procedure can be specified with the AT EOJ command. All commands following "AT EOJ" to the end of the script are executed when end of file is hit on the primary input file. The EOJ procedure is not allowed to perform another procedure - this restriction will be removed in the next release. SCRIPT ON / OFF command The SCRIPT ON or OFF command turns the printing of your script on or off. If the first command of your script is "SCRIPT OFF", no script headings or script listing is printed. STATS command The STATS command tells Data-Miner where you want run statistics to be printed - PRINTER, CONSOLE, BOTH or NONE. The default is PRINTER. Specifying CONSOLE allows the STATS to be accessed by CSI-FAQS to decide on further processing. CALL and RETURNS CALL calls an external load module or phase, passing up to 256 parameters which can be any variable that has been defined to Data-Miner. E.g. CALL XYZMOD USING AMOUNT RESULT RETURNS puts the return code from the previous CALL into a field e.g. RETURNS SUCCESS-OR-FAILURE