[sqr-users] Managing large datasets IN SQR

["Jessie Dickenson" <JMDICKENSON@rainbow-media.com>]

I am working with a report which calls a PL/SQL package that inserts the 
reporting data to a temp table. Once package exection is completed, the 
inserted row count stands at roughly 250,000. Then my SQR program begin 
selecting each row & prints it in a Detailed layout report. 
The Select statement is a very simple one:

BEGIN-SELECT ON-ERROR=SQR_ERROR(1,'Detailed_Section') 
CITY    &city
ADVERTISER_NAME  &advertiser_name
INVOICE_ID   &Invoice_ID
GROSS_RATE   &gross_amt
NET_RATE   &net_amt

 Move &city               to $city_str         
 Move &advertiser_name   to $advertiser_str 
 Move &Invoice_ID        to #Invoice_ID_str
 Move &gross_amt         to $gross_amt_str
 Move &net_amt           to $net_amt_str
 
 DO Print_Detailed_Row
 
FROM
 SCHEMA.TMP_TABLE TMP_TABLE
WHERE 
 TMP_TABLE.RUN_ID = #rpt_run_id
ORDER BY
 [$Order_By_str]
END-SELECT 
END-PROCEDURE Detailed_Section


In doing so, I am getting an error that the SPF file has become corrupt. The 
following is the error message:



I would greatly appreciate your help.

Thanks, Jessie
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users