How Sqr Programs Are Evaluated And Executed At Different Times?

1.	How Sqr Programs Are Evaluated And Executed At Different Times?
Answer» FIRST PASS: Or Compile stage. SQR processes the FOLLOWING components of the program. All # include external source files (SQCs) are inserted into the source program. All # commands are evaluated. The setup section is processes including allocation and population of memory arrays created by the load-look up command. OPTIMIZATION of the SQL data access path is determined. Checks syntax of SQR source program. SECOND PASS: Actual execution of the program source occurs starting at the begin Report stopping at the end-report. Process data for the body section. Senses page overflow or response to new-page command in code. Process heading section Process FOOTING section Writes entire page buffer to file. FIRST PASS: Or Compile stage. SQR processes the following components of the program. SECOND PASS: Actual execution of the program source occurs starting at the begin Report stopping at the end-report.

Answer»

FIRST PASS: Or Compile stage. SQR processes the FOLLOWING components of the program.

All # include external source files (SQCs) are inserted into the source program.
All # commands are evaluated.
The setup section is processes including allocation and population of memory arrays created by the load-look up command.
OPTIMIZATION of the SQL data access path is determined.
Checks syntax of SQR source program.

SECOND PASS: Actual execution of the program source occurs starting at the begin Report stopping at the end-report.

FIRST PASS: Or Compile stage. SQR processes the following components of the program.

SECOND PASS: Actual execution of the program source occurs starting at the begin Report stopping at the end-report.

Discussion