[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Nested begin-select blocks



Hi all.

I'm writing a couple of reports that have nested begin-select blocks i.e..

        begin-select
        job_numbers
                !for each job number call procedure to select job details
        from
        some_table

The details from each job number will make up individual *.lis files.

I was just wondering if this would cause a performance issue and whether I
would be better off joining the two select blocks together and breaking on
job number to print out the individual details.  In terms of readability and
ease of programming I find the nested route easier to develop.

I would appreciate it if anyone could give me some advice (in regards to
performance) based on prior experience.

Thanks.
John Milardovic