PROC Buffers

PROC uses buffers to handle information. It uses input and output buffers. These are the principal data storage areas.

The output buffer is where the TCL commands are placed prior to buffering. The user responses go into the input buffer.

The data is separated by characters called "buffer reference". They are as follows:

The simplest type of PROC is where you can perform a single TCL operation. For example, perform the English command, SORT STAFF BY DEPT.

Here, PQN informs the database system to interpret the lines by a PROC processor. It should be the first attribute in any PROC. The MV command places the string, SORT STAFF BY DEPT into the first field of the output buffer. It moves the information around. The 3rd line, #1 indicates the output buffer in the first field.

The P command processes the content of the output buffer and generates the English report.