SELCOPYi_Brochure_zOS

SELCOPY/i - Interactive The Unique multi-windowed 3270 environment SELCOPY/i is a Unique Advanced Data Management Tool enabling an enterprise to quickly and easily locate and edit any file on disk to correct invalid data, plus every-day files, like JCL and Source. Major productivity benefits over using ISPF through its intuitive windows style interface, familiar to PC Users. SELCOPY/i supports both ISPF and List Windows provide an easy SELCOPY/i also includes a simple XEDIT functionality but also interface to work on lists of volumes, to use Dynamic SQL interface to contains many unique features, such datasets, libraries and members. All DB2. as drop down menus, list windows, list windows support sort on head- virtually unlimited edit sessions, 64 ings, selective columns and filtering All SELCOPY/i windows can be levels of undo/redo per edit session, of data to effectively reach the data moved around the desktop and cut/paste, line and block copy. required. minimized/maximized to suite the user. Unique Point & Shoot Command List windows also support standard Centre, where commands are stored ISPF and SELCOPY/i prefix All SELCOPY/i tools can also be and executed with a single key commands. A single key press on invoked from the command line or press. This removes the need for any window entry will open the entry from a line in the command file. repeated typing of file names and as a new list or edit if item is a file. command syntax. Users can effectively drill down The output of TSO commands can through the system to locate the file be captured in a window and Drop down menus simplify file or data they are seeking. browsed or edited as a simple file. definition and allocation, DB2, dataset lists and execution of List Windows can be saved as a An ISPF hot-key is provided for SELCOPY/i built in tools. simple file for future reference or those rare occasions that ISPF is printing. required, or even go to numbered ISPF menu options directly.

SELCOPY/i - File Edit for z/OS The Unique multi-windowed 3270 environment Structured Data Edit is provided as a standard feature of SELCOPY/i providing a modern enterprise class editor for very large files using copybook structures. This enables Developers and Application Support staff to make timely and efficient corrections to any business critical enterprise data. Designed for Development staff to Structured Data Edit provides users FSU (File, Search & Update) makes resolve production problems quickly with the tools to make interactive it easy for a developer to identify in both interactive edit and through changes to data and generate test global changes that would occur, the SELCOPY batch interface. data in VSAM, SEQ and PDS(e) before actioning them if all is ok. files, with the minimum of effort. He can even UNDO it using the Quickly and easily edit any file on audit trail, if afterwards it proves disk regardless of region or file size Isolate any records/fields with to have been a mistake. using a COBOL or PL1 copybook. sophisticated SQL like SELECT and WHERE sub commands. HFS/zFS file systems are viewed in Open multiple views of the same an explorer style window, complete data and view multiple record types Easily switch between different data with standard point & click access concurrently, Zoom into a single views and save the select statement to drill down through the directory record as a vertical view of the in the command file for future structure and edit a file. execution. Multiple single record views may be A command line interface is also opened concurrently to compare the The CBL Structured Language available to manage the HFS/zFS entries. enables file structures to be created files and directories. for a file with no copybook available. TECHNICAL SUPPORT CBL Support and help desk is completely free to licensed customers. Your feedback drives our Software Development!

SELCOPY/i - Batch Multiple Information Retrieval, Manipulation & Update Card Any mix of Input/output data Printer RELIABILITY VSAM SELCOPY VSAM SELCOPY has gained an DB/2 PROCEDURE DB/2 enviable reputation with Adabas Adabas customers as a reliable (Batch, TSO PDS(e) programming tool, for PDS(e) or Interactive ) IMS production procedures and IMS SEQ for quick fixes. SEQ SELCOPY can get you out Tapes of trouble fast. Tapes PLATFORM SUPPORT SELCOPY requires no compiling and is much easier to code than Printing choices include, char, hex, both, mixed, dump or report. SELCOPY is available for all compiled languages such as COBOL, PL1 and C++, while Alternatively convert some fields, rearrange them and print a mainframe environments. executing at comparable speeds. subset. SELCOPY is also available Read data from any mix of input data into any mix of output data in DB/2, IMS, DL1 and ADABAS database systems supported on other platforms (UNIX, a single run. e.g. IMS to DB2. within the base product. iSeries and Windows). Non-mainframe versions READ, INSERT, DELETE and UPDATE DB/2 database tables. IF/AND/OR, THEN/ELSE, PERFORM/GOTO logic control can all read and write Dynamically generate and execute SQL statements. statements and ADD/SUB/MULT/DIV for arithmetic data types. exported binary format native mainframe files. Full VSAM support for update in place, keyed read, sequential Conversion includes ASCII/ EBCDIC and printable hex as well (forwards/backwards), insert and delete. as arithmetic data types. INTERACTIVE Selectively update DB2 tables based on input data from other Supports concatenation of datasets of different DSORGS. SELCOPY batch is included sources. Read and Write data on DB2, IMS, DL1 and ADABAS e.g. VSAM, DB2 table, sequential file. with the SELCOPY/i databases and produce reports. interactive environment. Manipulate data down to the bit level, process Char/Bin/Packed Dynamic Allocation simplifies JCL requirements for existing Decimal fields. datasets. PORTABILITY Generate test data, to create many test files from one input file, A single SELCOPY procedure adds conditional processing Common syntax is used multiple input files or from nothing at all. capability to replace multiple IBM utility steps. across all platforms, so code can be easily ported with Changing Fixed, Variable, Undefined and re-blocking is just a small Call external routines written in Assembler/Cobol or any little or no changes. part of what is possible. You can restructure any non-IBM file into programming language that uses Language Environment. standard IBM format. DIRDATA parameter to read both directory and member data Large Block Interface support. records from a PDS/PDSE. CONTACT SELCOPY/i provides an Interactive Debug environment for development of the more complex Compute (Bridgend) Ltd batch SELCOPY programming requirements. 8 Merthyr Mawr Road, BRIDGEND, CF31 3NH +44 (0)1656 652222 www.cbl.com

SELCOPY/ i - DB2 Edit (New for 1.9) The Unique multi-windowed 3270 environment SELCOPY/i contains an advanced DB2 Management, Testing and Modelling tool, enabling organisations to quickly and easily manage their complex DB2 data structure in an intuitive windowed environment. The DB2 Primary Option Menu Alternatively, user written REXX Browse/Edit DB2 tables alongside Window is the starting point for macros can prompt for variables standard sequential, VSAM, HFS/ management and control of your before building and executing a zFS and PDS files. DB2 environment. DB2 query. “Save As ...” function which allows: Quickly and easily generate Lists of Storage Groups, A new table to be created as a complex SQL commands, Databases, Tables and Views, each subset of an existing table. manage tables and objects, Browse/ in their own window, with standard Edit tables, UNLOAD and RELOAD point-and-shoot to drill down to your May be saved as a standard tables. required entry, with a drop down SEQ, VSAM or HFS file. action menu for more options, e.g. SELCOPY/i for DB2 assists users to zoom to single record view. Export to plain text or CSV develop DB2 queries which can be file for distribution to other saved for repeated execution in the SELCOPY/i for DB2 supports platforms or for email. current or subsequent SELCOPY/i concurrent connections to sessions. multiple DB2 subsystems (for Display groups of table rows in example live and test subsystems) separate views, or show several The Command Centre system with a full audit log for each rows each in a separate vertical supports embedded variable names individual DB2 connection. format window. which can be set prior to exec, allowing very complex commands to Run SQL queries on a results set. be actioned.