Difference between revisions of "Test268 Section 1"
From MidrangeWiki
(→Use externally described database files in a program) |
(→Create DDS externally described files) |
||
| Line 53: | Line 53: | ||
=== Create DDS externally described files === | === Create DDS externally described files === | ||
| − | + | A R CURCOEMAIL | |
| + | A CMPNY 4 0 | ||
| + | A EMAILADDR1 100 | ||
| + | A EMAILADDR2 100 | ||
| + | A K CMPNY | ||
=== Create SQL externally described files === | === Create SQL externally described files === | ||
Revision as of 16:31, 29 November 2005
<< Previous Section | Home | Next Section >>
Contents
- 1 Section 1 - Externally Described Files in Programs (14%)
- 1.1 Use printer files and "O" specs to define output in a program
- 1.2 Use database file I/O operations in a program
- 1.3 Use display file I/O operations in a program
- 1.4 Use externally described database files in a program
- 1.5 Use externally-described printer files in a program
- 1.6 Use externally-described display files in a program
- 1.7 Create DDS externally described files
- 1.8 Create SQL externally described files
- 1.9 Use EXTFILE. EXTMBR and OPEN/CLOSE file operations in a program
- 1.10 When using externally described files, rename fields
- 1.11 When using externally described files, show how to rename record formats in a program
- 1.12 Create Physical, Logical/View, Printer, and Display externally described files
- 1.13 Use a field reference file to create an externally described file
Section 1 - Externally Described Files in Programs (14%)
Use printer files and "O" specs to define output in a program
Use database file I/O operations in a program
Grab one particular record in a file:
chain (employee) empfile;
Write a record:
write roperator;
Set the pointer to a spot in the file then read all records that match the key:
setll (employee) emphist;
reade (employee) emphist;
dow not %eof();
::: Logic here :::
reade (employee) emphist;
enddo;
Update a record:
update record;
Use display file I/O operations in a program
Write a display record:
write footer;
EXFMT:
exfmt screen1;
Read a display record:
read screen;
Use externally described database files in a program
FFilename++IPEASF.....L.....A.Device+.Keywords+++++++++++++++++++++++++++++Comments++++++++++++ FMYFILE IF E K DISK
Use externally-described printer files in a program
FFilename++IPEASFRlen+LKlen+AIDevice+.Keywords+++++++++++++++++++++++++++++Comments++++++++++++ FREPORT O E PRINTER USROPN OFLIND(*IN40)
Use externally-described display files in a program
Create DDS externally described files
A R CURCOEMAIL
A CMPNY 4 0
A EMAILADDR1 100
A EMAILADDR2 100
A K CMPNY
