RE: [sqr-users] Flat File Limitations

["Mark Hall" <Mark.Hall@parkview.com>]

If you are running into the 2G file limit you need to process the file
in a file system that is "large file enabled."  In some file systems I
run into this limit when I am doing an export of an Oracle database. 
But certain file systems are, as I said, "large file enabled" and they
except files sizes greater than 2G.  Talk to your Unix system
administrator.  That is, if you are processing this file on a Unix box. 
It may just be that you need to use a different file system.
 
Mark Hall
IS Analyst
ERP Team
Parkview Health Systems
Fort Wayne, IN 
260-373-8796
mark.hall@parkview.com


>>> raj.srinivasan@hccs.edu 07/02/04 10:12AM >>>
There was a similar problem at one of the big PS shops, and the
resolution
was to split the file into manageable size and then process
sequentially.

Thanks!!!

Raj

-----Original Message-----
From: sqr-users-bounces+raj.srinivasan=hccs.edu@sqrug.org 
[mailto:sqr-users-bounces+raj.srinivasan=hccs.edu@sqrug.org]On Behalf
Of
Ray Ontko
Sent: Friday, July 02, 2004 10:04 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: Re: [sqr-users] Flat File Limitations


Is it somewhere near 1024000 records?  If so, then you're probably
bumping into a 2GB file limit.  I'm not sure whether you'll be able
to easily get around this.

Ray

On Fri, Jul 02, 2004 at 06:54:48AM -0400, Pink, Michael wrote:
> Yeah we are getting a core dump after a certain number of rows are
met.
> The record length is 2098 and on HP unix.
>
> -----Original Message-----
> From: sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org 
> [mailto:sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org] On
Behalf
> Of Ray Ontko
> Sent: Thursday, July 01, 2004 4:44 PM
> To: This list is for discussion about the SQR database reporting
> languagefrom Hyperion Solutions.
> Subject: Re: [sqr-users] Flat File Limitations
>
>
> I'm not aware of any.  Are you running into a problem?  What
operating
> system?  Fixed or varying length records?  If fixed, what record
size?
>
> Ray
>
> On Thu, Jul 01, 2004 at 04:07:00PM -0400, Pink, Michael wrote:
> > Hi,
> > Does anyone know if there is a size limitation for writing flat
files
> in
> > SQR?
> > Mike.
> >
> > _______________________________________________
> > 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 
>
> _______________________________________________
> 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 


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


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