File Access ver 9.0
Oasis Software International
3949 Champagne Ave.
North Port, FL 34287
Phone: (402) 321-9802
Web Site: www.Oasis400.com
e-Mail contact: Sales@Oasis400.com
What's new in File Access 9.0 ?
New free CPYFRMJRN command incorporated into File Access
The new command CPYFRMJRN will copy journal entries to an output
file with the journaled file's current field layout attached.
You can specify OBJTYP(*JRN)on the STRFA command. This option will retrieve the journal entries for the file specified.
From within File Access, you can enter JRN or JRN ? to display the
journal of the current file.
Confirm update option
In the WRKFAPRF, there is now an option to confirm the adds, changes
and deletions made within File Access.
New journal log option.
If print audit report default is "Y" and a File Access journal file
is specified, a journal log of the print file is created. This log
shows the before and after images of each changed field.
Record file opens.
In the WRKFAPRF command, you can now specify to record when a file
is opened using File Access.
SQL view support.
More SQL view support including calculated fields.
Chinese/Korean character display support.
You can now view Chinese and Korean DBCS fields.
New PRTREC control command.
This control command will print each selected field text and value
in a single line format.
Keep fields on display option.
This option allows you to keep selected fields on the screen in
multiple record view.
From the field selection screen, press F7 to format fields and enter
a 'Y' in the "keep" field.
What's new in File Access 8.0 ?
Select Parameter
You can send the SQL select command with the STRFA coammand.
The new parameter is STRFA FILE(yourlib/yourfile) select('CUSTDUE >1000') for example. .
Order Parameter
You can send the SQL order command with the STRFA coammand.
The new parameter is STRFA FILE(yourlib/yourfile) order(CUSTSTATE, CUSTDUE DESC) for example.
Keys are shown as ascending or descending on select field screen
The key fields in the select field screen now show as A01, D02, etc.if keys are ascending or descending
Data Queue Support
You can now look at data queue entries by specifying the object type (*DTAQ).
Data Base Relations screen leaves search criteria on screen
When searching from the data base relations screen, the search field is no longer cleared after a search.
Control field has a separate option for color and cursor highlight
You can now specify if the control field has the cursor highlighted.
You can also select the control field color separately.
What's new in File Access 7.0 ?
*EXPORT macros
You can save any JOIN, ORDER, SELECT commands plus selected fields and export the entire view to a macro.
These macros can be run interactively or in batch.
The new parameter is STRFA *EXPORT MACRO(lib/macro).
Count control
You can count the number of rows in a file.
This includes the ability to count rows in conjunction with JOIN and SELECT statements.
For example, you can see how many order detail records do not have order header records
by entering the JOIN command "RIGHT JOIN ORDDTL ON ORDHRD.ORDNBR = ORDDTL.ORDNBR"
then entering the command COUNT.
The number of rows from the JOIN would be returned.
*FILE control
The control FILE displays the current file information
Enhanced File Information
The file information screen now shows more information including journal and triggers
Field Search From All Field Lists
You can now press F14 to search for fields from all displays with field lists.
SQL Statements Are Displayed In Expanded Mode
The JOIN, ORDER, SELECT statements are now shown on the main File Access screen
The SQL statements color can also be changed through the display options screen
Open Other Object Types
You can now select other object types when opening a new file.
The object types are *USRSPC, *DTAARA, and *MSGF
Open File/Member Changes
When opening a new file from within File Access, the keyed member name is now used
Previously, if you changed a file name, the member defaulted to *FIRST
132 Column Support For All Screens
Also, if the current screen is 132 column mode, File Access will start in 132 column mode.
Export To Print
You can now export a file to *PRINT.
*LDA / *GDA
You no longer have to specify OBJTYP(*DTAARA) when opening *LDA or *GDA.
What's new in FAE 6.0 ?
Powerfull SQL commands JOIN, ORDER, SELECT built in to File Access
JOIN Command
Allows you to join multiple files together.
For example, if you were displaying an order header file e.g.(ORDHEADER),
you could issue the join command, JOIN ORDERDTL ON HDRORD = DTLORD.
You could now display and change matching ORDHEADER and ORDERDTL records at the same time.
If you undo a change, both file changes are reversed.
If you are using the journaling function of File Access, both files are journaled
individually.
You can specify LEFT, RIGHT, INNER, and EXCEPTION joins.
For example, you could enter from the order header file:
EXCEPTION JOIN ORDERDTL ON HDRORD = DTLORD
This example would show you all of the order header records that were missing detail
records.
Uses Standard SQL join syntax.
ORDER Command
Enter the order of the file.
For example, entering COMPANY, SALESREP DESC will create a index in company, then
salesrep with salesrep in descending order.You can then immediately press F7 and position to
the new key.
If you join files togther with the *JOIN command, you can create an order from the joined
file(s).
Press F4 for a list of fields to create the new file order.
Uses standard SQL "ORDER BY" syntax.
SELECT Command
Enter the selection criteria for the records to be displayed.
For example, entering COMPANY = 'OASIS' AND SALESREP IS NOT NULL AND (GROSS - > COST) >
100000,
would present a view of the file that meets that criteria.
If you join files together with the *JOIN command,
you can use selection criteria from all files.
Uses standard SQL syntax for SELECT.
EXPORT Command Support
Export the current file view to a file or export user program.
You can specify JOIN, ORDER, SELECT commands and select fields and export the entire view
to a new file or you can process the file yourself with an export user program.
The export file ##FAEEXP is created in QTEMP that your program can process.
Each profile can have their own user export program specified through the WRKFAPRF command.
The export function can be submitted to batch.
GROUP Command Support
Enter the File Access command *GROUP and you can open up to 16 files using a group job.
Press the attention key for a list of open File Access Files.
If you are already using group jobs, your job will appear in file File Access group job
window.
Press the attention program to display a list of open files.
Replace Value With Formulas
When replacing the value of a field, you can now specify an "@" in the beginning of the
replacement value to specify a formula is to be used to calculate the value of the new
field.
For example, you could replace the customer total amount due by specifying field(TOTDUE)
@AGE1 + AGE2 + AGE3 + AGE4.
Exclude Files/Libraries from WRKFAPRF
Through the WRKFAPRF command, you can now exclude entire libraries from being accessed by
File Access.
You can exclude and entire library and then include specific files in that library
IBM V6 compatible
File Access 6.0 is IBM V6 compatible.
What's new in File Access 6.0 ?
Powerfull SQL commands JOIN, ORDER, SELECT built in to File Access
JOIN Command
Allows you to join multiple files together.
For example, if you were displaying an order header file e.g.(ORDHEADER),
you could issue the join command, JOIN ORDERDTL ON HDRORD = DTLORD.
You could now display and change matching ORDHEADER and ORDERDTL records at the same time.
If you undo a change, both file changes are reversed.
If you are using the journaling function of File Access, both files are journaled individually.
You can specify LEFT, RIGHT, INNER, and EXCEPTION joins.
For example, you could enter from the order header file:
EXCEPTION JOIN ORDERDTL ON HDRORD = DTLORD
This example would show you all of the order header records that were missing detail records.
Uses Standard SQL join syntax.
ORDER Command
Enter the order of the file.
For example, entering COMPANY, SALESREP DESC will create a index in company, then salesrep with salesrep in descending order.You can then immediately press F7 and position to the new key.
If you join files togther with the *JOIN command, you can create an order from the joined file(s).
Press F4 for a list of fields to create the new file order.
Uses standard SQL "ORDER BY" syntax.
SELECT Command
Enter the selection criteria for the records to be displayed.
For example, entering COMPANY = 'OASIS' AND SALESREP IS NOT NULL AND (GROSS - > COST) > 100000,
would present a view of the file that meets that criteria.
If you join files together with the *JOIN command,
you can use selection criteria from all files.
Uses standard SQL syntax for SELECT.
EXPORT Command Support
Export the current file view to a file or export user program.
You can specify JOIN, ORDER, SELECT commands and select fields and export the entire view to a new file or you can process the file yourself with an export user program.
The export file ##FAEEXP is created in QTEMP that your program can process.
Each profile can have their own user export program specified through the WRKFAPRF command.
The export function can be submitted to batch.
GROUP Command Support
Enter the File Access command *GROUP and you can open up to 16 files using a group job.
Press the attention key for a list of open File Access Files.
If you are already using group jobs, your job will appear in file File Access group job window.
Press the attention program to display a list of open files.
Replace Value With Formulas
When replacing the value of a field, you can now specify an "@" in the beginning of the replacement value to specify a formula is to be used to calculate the value of the new field.
For example, you could replace the customer total amount due by specifying field(TOTDUE) @AGE1 + AGE2 + AGE3 + AGE4.
Exclude Files/Libraries from WRKFAPRF
Through the WRKFAPRF command, you can now exclude entire libraries from being accessed by File Access.
You can exclude and entire library and then include specific files in that library
IBM V6 compatible
File Access 6.0 is IBM V6 compatible.
What's new in FAE 5.0 ?
Null File Support.
File Access now supports files with null fields.
DBCS File Support.
File Access now supports files with DBCS fields.
Big Integer Support.
File Access now supports files with Big Integer fields.
Message File Support.
File Access can now add/change/delete messages in message files :Use
the new parameter OBJTYP(*MSGF)
Data Area Support.
File Access can now display and update data areas. :Use the new
parameter OBJTYP(*DTAARA)
Highlighted Entry Field Support.
You can specify if you want the field with the cursor to be
highlighted.
DSP control commands.
The control DSP will go directly to the display options.
What's new in FAE 4.1 ?
Billion record suport.
File Access now supports files containing more than a billion
records.
Objects in QTEMP are rebuilt when needed.
File Access continues to function correctly even when other programs
clear QTEMP.
FTN and FNT control commands.
The control "FTN" will display the field text followed by the field
name.
The control "FNT" will display the field name followed by the field text.
User Space Support.
File Access can now display and update the contents of a user space.
There is a new parameter for object type OBJTYP(*USRSPC)
Large Field Support.
Fields in single mode that are larger the one screen can now be
displayed. The entire long field can be scrolled through to show the value
of the field.
WRKFAPRF Changes.
You can now delete a user profile when the user profile no longer
exists.
The File Access journal file can be created automatically for each
user.
V5R4 User domain changes
File Access user index routines now use only IBM APIs to retrieve
indexes.
What's new in FAE 4.0 ?
UNDO function. FILE ACCESS/400 now has an UNDO function. After making a change or changes to a file, you can “undo� on or all changes by keying “UNDO� in control field. To undo more than one change, enter UNDO(n) where n is the number of changes to undo or UNDO(*ALL) to undo all changes in the file you are accessing. You can undo any changes before signing off.
File Access Journal. Now FILE ACCESS/400 optionally writes all changes that occur with FILEACCESS to an internal journal file. The WRKFAPRF command allows you to enter the journal file to contain these changes. The file provided is #FAEJRN. When using FILE ACCESS to display this journal, the fields from the changed file are displayed.
Display deleted records. You can display and retrieve deleted records in a physical file by keying SHOWDEL in the control field. To hide deleted records (default), key HIDEDEL in the control field.
You can search for deleted records from the F14 screen. You can specify *UNDELETE for a replacement value that will restore the deleted record to the file.
Multiple records are displayed in formatted field mode. You can update and display multiple record files the same as single format file.
You can specify additional data rights using the WRKFAPRF. For example, you may stop changes to files in specified libraries even if you have rights to change those file with an application program.
F4 field now has “find text� function and a partial field name function. Key “*� in the position to field and the entire field name is searched for a match.
WRKOBJ type STRFA command. FILE ACCESS now supports generic file, library and member parameters. For example, STRFA CUST* will display a list of all files starting with CUST. STRFA *ALLUSR/CUSTMAST will display a list of all files in user libraries named CUSTMAST. You can open the file directly from this list.
Variable length field support
Find a key/text from Data Base Relations screen
EBCDIC/ASCII parameter. A new parameter allows you to display ASCII data in EBCDIC format.
WRKFAPRF now allows a user to specify the title displayed at the top of FILE ACCESS. Special keywords are allowed including: &file to display the opened file text. &file(c) to display the file text centered, &system do display the system name and &system(c) to display the system name centered.
Searching records now shows you the number of records searched and found.
You can now select from a list of members from the open file screen.
*PRV parameter works even after abnormal termination of job.
Field length and positions are shown when pressing F4 from the search screen
New Fast Path Commands include:
"MBR" display the members in the currently opened file.
"SHOWDEL" show deleted records.
"HIDEDEL� hide deleted records (default).
"UNDO (n) – UNDO the last n changes to a file (1 is the default).
“UNDO(*ALL) – UNDO all changes to a file