Re: Maximum SQLSIZE

["Love, Kristin" <klove@MSA.COM>]

Just in case anyone cares..............
on our NT system running SQR 4.2.3 under ORACLE 7, the most I could set the
SQLSIZE to was 33,400

any SELECT statement larger than that caused an ORACLE error.

:( Kristin

> -----Original Message-----
> From: Art DiRamio [SMTP:ADiRamio@OPENSOLUTIONS.COM]
> Sent: Monday, September 27, 1999 11:09 AM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: Maximum SQLSIZE
>
> 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