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

Raz-Lee Security, a major world-wide vendor of security solutions for IBM Power i computers, has enhanced its feature-rich SOX and PCI compliant file editor, FileScope, with full Unicode (UTF-16, UCS-2) support, to comply with the prevalent international standard. Unicode support is totally unique in the Power i data manipulation market and encompasses ALL FileScope facilities including Substring, Scan and Subset functions.

Unicode, a fundamental building block for international e-business, allows data from many different languages to be stored in one repository. Today’s business world demands that IT systems be able to present content and conduct transactions in all major worldwide languages. Unicode enables a single set of application source code to be written to process data in any language. It also makes the addition of new language support to an existing e-business application relatively simple since character processing and storage remains unchanged. This results in lower costs of implementation, faster time to market, and higher customer satisfaction.

FileScope is packaged in both Gold and Platinum versions, both of which support the new Unicode capability. While technologically similar, the Platinum version supports more SOX, PCI, auditing and file journaling capabilities, making it more appropriate for large and mid-sized shops.

As part of the announcement, Raz-Lee will provide, for a limited time, FileScope/Gold with Unicode Support at $0(!) including free maintenance for up to three months.

FileScope’s Unicode support enables viewing SAP, JDE, MOVEX, BPCS, and other files. The following functions are supported for these and similar files:

• Display file contents
• Print file contents
• Update records (single record, full screen, global changes)
• Scan for fields
• Subset records (OPNQRYF) including all Tests such as EQ….LIKE 
• Substring field values
• Undo changes (up to 99 days)

Raz-Lee also offers FileScope Platinum, an upgraded version, which includes (in addition to the Gold Edition features):

• Improved SOX/PCI support
  • SYSLOG/SNMP Messages for SIEM – transmits up to 1000 lines per second.
  • User Activity List Email – including users, times and actions.
• XML support
• Report Generator
• Full Screen Update

 ”A Unicode-supporting file editor is a highly desirable product, unrivaled by any other company, and we’ve already witnessed the demand for it” said Shmuel Zailer, CEO, Raz-Lee Security. “It is a fitting enhancement for our FileScope product, which is already well-stocked with unique features such as Undo, Join and User activity list emails – also unique to Raz-Lee’s technology.”