Re: [sqr-users] Managing large datasets IN SQR

[Ray Ontko <rayo@ontko.com>]

What's the error message?

Ray

On Fri, Jun 11, 2004 at 03:31:40PM -0400, Jessie Dickenson wrote:
> 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

----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/

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