PREPARE AFILE Examples
Example 1:
|
|
|
|
|
|
|
|
|
Logical file: |
EMP |
|
Text file: |
EMPL.??? (.TXT under SUNDB86x or as defined in screen definition file under PLBCM.) |
|
AAM file: |
EMPL1.??? (.AAM under SUNDB86x or as defined in screen definition file under PLBCMP) |
|
Key info: |
(2 keys (3-5 & 10-20), wildcard is `?'(default), non-case sensitive searches (U)) |
|
Record length: |
100 |
|
Mode: |
SHARE (by default) |
Example 2:
|
|
|
|
|
|
|
|
|
Logical file: |
EMP |
|
Text file: |
EMPL.??? (.TXT under SUNDB86x or as defined in screen definition file under PLBCMP) |
|
AAM file: |
EMPL2.??? (.AAM under SUNDB86x or as defined in screen definition file under PLBCMP.) |
|
Key info: |
(2 keys (1-15 & 20-25), wildcard is `^', case sensitive searches) |
|
Record length: |
150 |
|
Mode: |
EXCLUSIVE |
Parameters given as literals could have been variables.
Example 3:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Logical file: |
AFILE |
|
Text file: |
filelst.??? (.TXT under SUNDB86x or as defined in screen definition file under PLBCMP.) |
|
AAM file: |
filelstx.??? (.AAM under SUNDB86x or as defined in screen definition file under PLBCMP.) |
|
Key info.: |
(2 keys (1-5 & 20), case sensitive searches) |
|
Record length: |
20 |
|
Mode: |
CR only, Share No Flush and no truncation |
Example 4:
|
|
|
|
|
|
|
|
|
Logical file: |
EMP |
|
Text file: |
C:\PAYROLL\EMPL.??? (as defined in screen definition file) at the server. |
|
AAM file: |
C:\INDEX\EMPL1.??? (as defined in screen definition file.) at the server |
|
Key Info: |
(2 keys (3-5 & 10-20), wildcard is `?'(default), non-case sensitive searches (U)) |
|
Record length: |
100 |
|
Server address: |
209.20.30.5 |
|
Server port: |
503 |
|
Mode: |
SHARE (by default) |
Example 5:
|
|
|
|
|
|
|
|
|
Logical file: |
EMP |
|
Text file: |
textfile.??? (as defined in screen definition file.) |
|
AAM file: |
aamfile.??? (as defined in screen definition file.) |
|
Mode: |
SHARE (by default) |
|
Cancel key: |
the ESCape key |
|
Check interval: |
one second |
![]() |