RE: [sqr-users] write error

[Peter Burton <pburton@brio.com>]

Eswary,

SQR is a 32-Bit executable and hence has limitations along those lines.  The
version of SQR you are using cannot deal with files greater than 2 gigabyte
in size.

This has been addressed in a later release (SQR 8.1).  The product is still
32-Bit but can access files greater than 2 gigabyte as long as the
underlying file system and OS supports "large files".

Peter

-----Original Message-----
From: Eswary.Rosicke@anthem.com [mailto:Eswary.Rosicke@anthem.com]
Sent: Wednesday, May 14, 2003 1:58 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] write error


Hi!

   This is an error on my production box. I have attached the log below.
   Please help asap. Thanks!

   The SQR error is 3203.
   Two flat files (Group and Member, each with fixed-length lines) were to
   be created by this aix jobshell.
   The database is on a sybase server.
   The Group file created successfully without incident.
   But the Member file failed with the SQR Error 3203 when the file was
   almost 2.15 Gigabytes.
            46262521 May 13 08:07 im02_swp_grgr_phi.out
            2147483647 May 13 16:15 im02_swp_meme_phi.out


   Does Sqribe have a filesize limit when creating a flat file?
   In a separate incident, I'd seen that another program had failed when it
   was writing out to a .lis file and that job failed too, when the file
   size reached around 2Gigbytes. Is it true that Sqribe has a limit on the
   file size being created.

   Is there a variable I need to declare (and where) to allow the job to
   create fixed-length flat files that are bigger than 2Gbytes.


   -- Log --
         Running IM02 PHI format file for group data
         SQR V4.3.2.2
         Copyright (C) SQRIBE Technologies, 1994-98.  All Worldwide Rights
         Reserved.
         SQR: End of Run.
         Completed im02_swp_grgr_phi.sqr :  2003/05/13 08:07
         Return Code:  0
         Running IM02 PHI format file for member data
         SQR V4.3.2.2
         Copyright (C) SQRIBE Technologies, 1994-98.  All Worldwide Rights
         Reserved.
      (SQR 3203) Line 169: Error writing the file.
         (0): Error 0
         SQR: Program Aborting.
         Processing Stopped:  2003/05/13 16:21
         Error in execution of im02_swp_meme_phi.sqr
         Return Code:  1



Eswary Rosicke

Anthem IT
Case Implementation Development
Phone: 203.234.5149




CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
and privileged information or otherwise protected by law.  Any unauthorized
review, use, disclosure or distribution is prohibited.  If you are not the
intended recipient, please contact the sender by reply e-mail and destroy
all copies of the original message.



_______________________________________________
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