SQR Questions

1. Ask Input difference?

a. ASK - compile time commands (which is used to get input from the user)

b. Input - run time command (which is used to get input from the user)

2. Load-lookup? Where to place in sqr?

a. Load-lookup - used like an array (see the SQRs book which u have) it should be given in the setup section

b. The LOAD-LOOKUP command defines an array containing a set of keys and values and loads it into memory. The LOOKUP command looks up a key in the array and returns the associated value. In some programs, this technique performs better than conventional tables join

c. You can use LOAD-LOOKUP in the SETUP section or in a procedure. If used in the SETUP section, it is processed only once. If used in a procedure, it is processed each time it is encountered.

d. LOAD-LOOKUP retrieves two fields from the database, the KEY field and the RETURN_VALUE field. Rows are ordered by KEY and stored in an array. The KEY field must be unique and contain no NULL values.

e. When the LOOKUP command is used, the array is searched (using a "binary" search) to find the RETURN_VALUE field corresponding to the KEY referenced in the lookup.

3. What is the standard SQC?

a. Prcsdef.sqc, Prcsapi.sqc, Setenv.sqc, Stdapi.sqc

b. SQC - Structured Query Language (SQR) common code file.

4. What is diff b/w show and display?

a. One field at a time is display and show many fields at a time.

5. How to create multiple reports?

a. SQR enables you to define HEADING and FOOTING sections for each report. This example defines only the heading and footing for the listing report, because the other two reports do not use them. The FOR-REPORTS option of the BEGIN-HEADING and BEGIN-FOOTING commands specifies the report name. The parentheses are required. Note that the USE-REPORT command is not needed in the heading or the footing. The report is implied by the FOR-REPORTS option.

b. Writing multiple reports simultaneously with one program reduces database queries.

c. You can define separate reports in the SETUP section.

d. USE-REPORT sets the printing context for each report.

The FOR-REPORTS option of BEGIN-HEADING and BEGIN-FOOTING defines headings and footings for individual reports