[sqr-users] 1/2 million row input file erroring out

[Christine Sessler <cms41@cornell.edu>]

Folks -

Request for immediate help!

I'm posting this for a colleague of mine.  We're running a CR conversion 
test and the input file is about 1/2 million rows of data.  The SQR is NOT 
doing any inserts/updates/deletes (at this time) and is doing a core dump.

Has anyone had any experience with processing such large input 
files?  Thoughts on what might be causing this?

Thanks!
Chris


>X-Sender: bb57@postoffice.mail.cornell.edu (Unverified)
>X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9
>Date: Fri, 06 Jun 2003 11:29:09 -0400
>X-PH: V4.1@postoffice.mail.cornell.edu (Cornell Modified)
>To: cms41@cornell.edu (Christine M Sessler)
>From: Satish Narayan <sn94@cornell.edu> (by way of Bruce Barber 
><bb57@cornell.edu>)
>Subject: help
>
>We are having a custom sqr(originally delivered by PeopleSoft but has been 
>bastardized by us) erroring out when it tries to process about half a 
>million rows of data. It created a core file on UNIX and looking thru the 
>core file, there seemed to be some references to the -ZCF switch. More 
>specifically, there was a line that said
>
>Inappropriate use of -ZCF switch.
>
>We don't even use this switch when we invoke SQR.
>
>It appears that the -ZCF switch is used to specify a command file - I make 
>this assumption based on the syntax of the -ZMF and -ZIF switches. Does 
>anybody have more details on the -ZCF switch? Thanks in advance.
>
>- Satish

************************************************************
Christine Sessler
Cornell University
CIT/Business Information Systems
120 Maple Avenue
Ithaca, NY  14850

607.255.2816 - MARS Project
607.255.8149  - Maple Ave
607.255.6982  - Fax
cms41@cornell.edu
************************************************************
"Life shrinks or expands in proportion to one's courage." - Anais Nin
"If a dog jumps in your lap, it is because he is fond of you;
but if a cat does the same thing, it is because your lap is warmer." - 
Alfred North Whitehead
"When the eagles are silent, the parrots begin to jabber." - Sir Winston 
Churchill  

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