Answer»
- Report or Program – Determines where SQR will begin and end execution of your report. People soft uses this section to control the flow of processing by calling procedures using the do command, thereby utilizing modular programming.
- Setup Section – Contains commands, which describe the general report characteristics (Note: the setup section is preprocessed and is automatically run before the program begins execution. This section can only include SQR commands.
- Programming section –
- Begin – SQL: The SQL paragraph allows you to execute any non-select SQL Statement.
- Begin-Document-: Allows you to mix background text. With the data retrieved from the database.
- Begin-Select: Select paragraph is the heart of the SQR program. For each row of data retrieved from the query, acting as an implicit while loop may also process a SET of commands there. Here you specify what columns of data to retrieve from the database. Other procedures may be referenced within a select paragraph, which in turn may contain other select paragraphs.
Note: In begin select SQR REQUIRES that columns names be flesh to the left margin and SQR commands be indented.
- Heading Section
- Footing Section
- PROCEDURE Section : A procedure is a LIST of commands or paragraphs, which are processed when referenced by a corresponding, do command. Procedure names must be unique. Procedures can contain regular SQR commands as well as three special kinds of paragraphs: A. SQL B. Document C. Select
Note: In begin select SQR requires that columns names be flesh to the left margin and SQR commands be indented.
|