Re: [sqr-users] write error

["the dragon" <ceprn@hotmail.com>]

Make certain your Unix system does not have a file size limit.  It looks 
like you have run up against an AIX file size limit.  Youe sysadmin can 
change this using smit, if he decides to.

clark 'the dragon' willis



PSA: Salary <> Slavery.  If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul.  Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent.  Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)


----Original Message Follows----

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

_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus

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