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 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.
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