File Access (New Version 11.0)

Features

  • Easily add, change, display or delete records in any data base file
  • Extensive security to limit file and library access
  • Optional journaling of all file modifications
  • Supports DBCS files
  • Supports null fields
  • Multiple files can be joined together and displayed, changed, ordered, searched, etc. at the same time
  • SQL SELECT, ORDER, UPDATE and JOIN support
  • Support for SQL views and aliases
  • Export the results of file select, join and order commands to files, printers or user defined programs
  • Save export macros and run them interactively or in batch
  • Support for data areas, user spaces, data queues, stream files and message files.
  • Display file information including data base relations, members, formats, triggers, journals, etc.
  • Flexible display options
  • Search, retrieve and restore deleted records
  • Easily display journals with the CPYFRMJRN command built into File Access
  • Use SQL functions on stream files
  • Use SQL functions over virtual fields

What's new in File Access 11.0?

SQL Criteria History

When using the SQL functions (SELECT, ORDER, JOIN, UPDATE), Pressing F9 will now display a history of previously entered SQL criteria for that user and file. From the history selection screen, you can change the library and/or file name. You can also search on the contents of the SQL criteria. For example, you can search for the following;

customer order = The search criteria must contain the words "customer" and "order"
(customer order) = The search criteria can contain the words "customer" or "order"
"cust" = The search criteria can contain the word "my cust" but not "customer".
customer-order = The search criteria can contain the word "customer" but not the word "order".

New Control "HST/HISTORY"

The control HISTORY will show all SQL history (SELECT, ORDER, JOIN, UPDATE) for that user and file. The SQL criteria will be ordered by SELECT, ORDER, JOIN, UPDATE. You can select one from each criterion.

You can also search on the contents of the SQL criteria.

Recent files

When selecting a file to open with STRFA *SELECT or F2 from within File Access, the last 30 opened files are displayed in the descending used order.

The field selections, display options, SQL controls, search functions, etc. are retained for each file.

New File Selection Options

When selecting a file to open with STRFA *SELECT or F2 from within File Access, you can now specify *PF or *LF to display only physical or logical files.

New File Search Options

You can now search for an object/library and/or text when selecting a file to open.

Search criteria can include multiple words and omit words that follow a "-".

For example, CUSTOMER FILE - ORDER would return all files that contained the words CUSTOMER and FILE but not the word ORDER.

New File Information

The file information screen now shows the long SQL name.

In addition to the journal information, the file information screen now shows if the file is currently journaled.

Data Base Relations Search Enhancements

The search line on the data base relations now allows omit words that follow a "-".

For example, ROUTE, STOP - INVDATE would return all files that contained the keys ROUTE and STOP but not the key INVDATE.

Data Base Relations Constraints

The data base relations will now show SQL constraints on the physical file or table.

If the constraint is a unique or primary key, the keys will be displayed.

If the constraint is a check, the check SQL for the constraint will be displayed.

If the constraint is a foreign key, the keys for the foreign and referenced file as well as the referenced file and library will be displayed. The delete and update rules are also shown.

Macro file, library and member name change.

The STRFA command now allows you to change a macro file, library and/or member name when specifying a *MACRO

When creating a macro, you can specify if the macro file/library/member can be changed.

New macro *SELECT

You can select a macro from the STRFA command by specifying *SELECT for the macro name.

New MAC control

You can create and change macros by entering MAC or MACRO into the control.

New OPT control

You can prompt for print/display options by entering OPT or OPTION into the control.

New RRN(D) control

You can display the file by relative record number in descending order.

New *dup/*dup+ option from the SQL selection screen

From the SQL selection screen, enter *dup and the SQL code return will be the correct criteria to show duplicate records based on the current index of the file.

Enter *dup+ and the SQL code return will be the correct criteria to show duplicate records plus the original record, based on the current index of the file.

New *dupdlt/*dup+dlt option from the SQL selection screen

Same as *dup/*dup+ but adds *DELETE to the SQL update option.


Click Here to download File Access

Purchase

System i Processor Group List Price Upgrade Price
P05 $1,495.00
$745.00
P10 $1,795.00
$995.00
P20 $2,095.00
$1,045.00
P30 $2,395.00
$1,195.00
P40 $2,695.00
$1,345.00
P50 $2,995.00
$1,495.00
Yearly maintenance fee: 15% of list price.

Want to try before you buy?

Request Free Trial