File Access (New Version 12.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 12.0?

JSON File Support

JSON File Support (V7R3 and above):

You can now display JSON files directly by using the new parameter file(*JSON). The parameter (STMF) is used to specify the JSON path.

The path can be an IFS file, or you can retrieve JSON from a web service by specifying HTTP://(website).

Examples:

STRFA *JSON STMF('http://fakestoreapi.com/products')

STRFA *JSON STMF('/json/jsonorder01.json')

New GETJSON Command (V7R3 and above):

The innovative GETJSON command can create a DB2 file from a JSON file. It can also create SQL selection criteria to transfer the file to a source member or printer. GETJSON can create three types of programs for parsing JSON files:

  • *PGM: Creates an SQL RPGLE program that will create a cursor based on the required SQL statement for the specified JSON file.
  • *PGM: Creates an SQL RPGLE program that will create a cursor based on the required SQL statement for the specified JSON file.
  • *SQL: Creates an SQL RPGLE program that will create a temporary file in QTEMP from the required SQL statement for the specified JSON file. The program will create inserts into a file based on the number of arrays found in the JSON document.
  • *PARS: Creates an SQL RPGLE program that will use DATA-INTO using a parsing program.
  • *SEL: Creates the required SQL select command to create a file from JSON using an SQL select statement.

New Control "USED/*USED".

The control USED will show the combinations of history SQL selections of 2 or more (SELECT, ORDER, JOIN, UPDATE) for that user and file. The SQL critria will be ordered by SELECT, ORDER, JOIN, UPDATE. You can select one from each criteria.

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


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