[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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