Re: Maximum SQLSIZE

[Art DiRamio <ADiRamio@OPENSOLUTIONS.COM>]

Kristin -

We have it set to 32756 here running SQR4 on Oracle 7, and it is running
fine.  (I think the number was the limit in SRQ3, and we have not had to
change in SQR4).

In SQR4, the variables that were in the file called by the -m option are
included in the SQR.INI file.

  - - Art  :-)


                -----Original Message-----
                From:   Love, Kristin [mailto:klove@MSA.COM]
                Sent:   Monday, September 27, 1999 10:21 AM
                To:     Multiple recipients of list SQR-USERS
                Subject:        Maximum SQLSIZE

                I know that the default SQLSIZE (which is the maximum length
of an SQL
                statement in characters) is 4000 in SQR. I know that you can
reset the
                SQLSIZE by using a -M file.

                But what would the MAXIMUM SQLSIZE be? This would probably
be dependent on
                your platform -- I am using ORACLE 7.

                What are the implications of resetting the SQLSIZE to a very
large number -
                like 45,000?  We have a 17 way union which has over 32,000
characters. My
                dynamic where clause adds on more characters, depending on
what is
                selected.....

                Believe it or not, the 17 way union actually runs!

                :) Kristin