Customer:
Mr. Didier Brisbois
Technical manager IT of IFAC
Hôspital Sainte Thérèse

My goal was to find a tool for DB2 databases which would provide me with:

• Full and robust reporting capabilities

• An easy to learn and easy to use product

• The ability to create special-purpose ViewPoints (file-specific pre-defined scripts) which can be used by unsophisticated users

• Batch processing capabilities in order not to tie-up the user’s session

• Minimal interference with AS/400 performance

Following is the list of benefits we have achieved using FileScope/Platinum:

• Quick and Easy

• Ability to perform batch processing

• Integration of FileScope into application menus

• Speed of the software, with many more options than Query

• Ability to make mass updates

• Journaling facilities to view temporary changes to a file by any user and also to monitor deleted records. (Note: These monitoring, tracking and reporting capabilities are especially important for companies which need to be HIPAA, SOX, PCI, etc. compliant.)

• Interactively viewing and editing file contents quickly and easily

• Product uses DB2-specific concepts (such as members, logical files, etc.) which is unique among products which support ODBC

• Short learning curve for most user’s queries

About FileScope

FileScope is recognized by Power i professionals as the leading Power i product in the area of data manipulation. FileScope provides unprecedented file editing capabilities, while adhering to the highest standards of quality, reliability and performance.

Features

• Cross-product Unicode UTF-16, UCS-2 support enables viewing SAP, JDE, MOVEX, BPCS, etc. files.

• Single e-mail contains all session changes

• Export to XML-format files

• Security, SOX and PCI support

• Full-Screen editor

• Save file-specific pre-defined scripts

• Field calculations

• Report generator

• Batch processing facility

• Multiple file management

• File scan and subset

• Special printing capabilities

• Log file changes

Written by Shari Masafy
Email Shari Masafy at
sharim@razlee.com