RE: [sqr-users] Removal of Carriage Control in SQR lis file

[James Womeldorf <jwomeldo@fastenal.com>]

Good luck.  I hope it works for you.

-----Original Message-----
From: Boddapati, Jagadish [mailto:JBoddapati@amerisure.com]
Sent: Monday, April 19, 2004 2:49 PM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: RE: [sqr-users] Removal of Carriage Control in SQR lis file


Hi Jim,
I will try this and let you know the results. Thanks a lot for your
quick suggestion.

Thanks,

Jagadish Boddapati
Application Developer Consultant
Amerisure Insurance Companies
Ph: 248 426 7888


-----Original Message-----
From: sqr-users-bounces+jboddapati=amerisure.com@sqrug.org
[mailto:sqr-users-bounces+jboddapati=amerisure.com@sqrug.org]On Behalf
Of James Womeldorf
Sent: Monday, April 19, 2004 3:28 PM
To: 'This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.'
Subject: RE: [sqr-users] Removal of Carriage Control in SQR lis file


Hi Jagadish,

If you have the book 'SQR in PeopleSoft and Other Applications' (Landres
and
Landres) look on page 255 at the section on creating flat files.  (If
you
don't have it I'd recommend it)
I use this:

begin-setup    
    DECLARE-LAYOUT NoFormfeed
        TOP-MARGIN = 0
        MAX-LINES = 999
        FORMFEED = No
    END-DECLARE        
    DECLARE-REPORT MYREPORT
        LAYOUT = NoFormfeed
    END-DECLARE
END-SETUP

Hope this helps,
Jim



-----Original Message-----
From: Boddapati, Jagadish [mailto:JBoddapati@amerisure.com]
Sent: Monday, April 19, 2004 1:45 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Removal of Carriage Control in SQR lis file




Hi,
I am trying to remove the carriage control from the LIS file generated
by SQR. There are about 80000 lines in the lis file and i am getting
carriage control for after every 32766 lines ( due to max limit on page
size buffer). So in the file with 80000 lines i am getting carriage
control in 2 places. I don't want to have this character in the lis file
as it would page break at that point. I can't increase the page size
more than 32766. 

Can you please let me know if you have any solution to this..
Jagadish Boddapati
Application Developer Consultant
Amerisure Insurance Companies
Ph: 248 426 7888



_______________________________________________
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

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