iSeries Data Manipulation
FileScope is recognized by System i professionals as the leading System i solution for data manipulation. FileScope provides unprecedented file editing capabilities, while adhering to the highest standards of quaility, reliability and performance.
FileScope has enabled thousands of System i users to quickly and easily perform both basic file editing and advanced activities such as global and local record updates, data conversion and creation of test data.
THE FILESCOPE SOLUTION
FileScope enhances general user productivity while providing user level tools to System Administrators and DBAs. FileScope’s simple and easy-to-use user interface alleviates the need to program code. Using FileScope, software development and maintenance times are greatly reduced, and problem troubleshooting is expedited. FileScope replaces ad hoc modification programs, reports, file generating programs, etc. and contains advanced error tracking and identification capabilities.
Unlike other information retrieval and manipulation methods such as DFU or QUERY, FileScope does not require compilation and definition steps. FileScope enables modifying database requests on the fly, performs record updates under your visual control, holds complete control over printing of reports and supports UNDO for any change.
Full-Screen EditorAccess and update all content on a multi-record screen. This will enable users to work on generically named fles, creating efficiency and time savings.
Field CalculationsFileScope includes a robust set of tools to define internal fields using formulas which can even be based upon external files and functions.
Multiple File ManagementReal-time, on-line Join capabilities in order to connect to other files. Supports Joined fields of different types and length.
The most efficient report generator around, both batch and interactive. FileScope’s unique capabilities include: reports using internal and/or calculated fields, reports using function-derived fields (e.g. external program), support for a range of keys, break level capabilities, transferring results to PC, subsetting data, and advanced page formatting.
Batch Processing Facility
Resource intensive activities, such as End-of-Day processing, can be processed in batch. Repetitive operations can be saved and ran directly in batch, without any on-line operator action.
FileScope offers a wide range of retrieval methods for locating specific records in a file or a subset of records.
Print an entire file structure, a single record or a group of records in a multi-record screen format. Standard product capabilities such as Sorting, Record Group Definition, Field Reorganization, etc., provide additional printing power.
Log File Changes
Log File contains all relevant historical
information regarding who created/modified data, thus allowing for easy
tracing of every modification. Includes the operations performed arranged
by user name, file name and time range.
Software Engineering of America Inc.,