Difference between revisions of "Test268 Section 1"

From MidrangeWiki
Jump to: navigation, search
(Use database file I/O operations in a program)
(Use database file I/O operations in a program)
Line 12: Line 12:
 
=== Use database file I/O operations in a program ===
 
=== Use database file I/O operations in a program ===
  
Chain a record:
+
Grab one particular record in a file:
       chain (dapivndgrp:dapivendor) venfmt;
+
       chain (employee) empfile;
  
 
Write a record:
 
Write a record:
 
       write roperator;
 
       write roperator;
  
SetLL and ReadE:
+
Set the pointer to a spot in the file then read all records that match the key:
       setll (dapiobjid) apdfmt;
+
       setll (employee) emphist;
       reade (dapiobjid) apdfmt;
+
       reade (employee) emphist;
 +
 
 +
      dow not %eof();
 +
        ::: Logic here :::
 +
        reade (employee) emphist;
 +
      enddo;
  
 
=== Use display file I/O operations in a program ===
 
=== Use display file I/O operations in a program ===

Revision as of 16:19, 29 November 2005

<< Previous Section | Home | Next Section >>

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;

Use display file I/O operations in a program

Use externally described database files in a program

Use externally-described printer files in a program

Use externally-described display files in a program

Create DDS externally described files

Create SQL externally described files

Use EXTFILE. EXTMBR and OPEN/CLOSE file operations in a program

When using externally described files, rename fields

When using externally described files, show how to rename record formats in a program

Create Physical, Logical/View, Printer, and Display externally described files

Use a field reference file to create an externally described file