SQR a Suppose we are giving three Lines are owed for Headin

###

SQR

a) Suppose we are giving three Lines are owed for Heading and Footing then how many Lines of data can be printed in the Body for a default size page. Please provide the answer with proper explanation.

b) It is possible to write multiple SQLs in a SQL Paragraph if yes please provide the Explanation

c) Presume there is no data to be printed in Procedure or Program section then will be heading and footing sections get processed

Solution

Answer A:

56 Lines. The rows available to the body of your report are calculated from the rows defined in PAGE-SIZE less the amount of rows held in reserve by the BEGIN-HEADING and BEGIN-FOOTING sections

Answer B:

Yes, but should be separated by Semicolon (;)

Begin-SQL

UPDATE ABC SET NAME = ‘Srinivas’;

DELETE FROM ABC WHERE NAME <> ‘Srinivas’;

End-SQL

Answer C:

No, if there is no data to be printed in Procedure and Program Sections then Heading and Footing sections will not be executed