August 22, 2006, 03:07 PM
KalLimit on number of 'WHERE ' Statements?
Hi!
Wondering if anyone has an idea on the Max number of 'WHERE ' Statements possible!
Browsed through the available docuementation on 'WHERE ' but no luck yet
My client here seem to be running queries with thousands of WHERE's and now trying to convert to WF.
I've suggested to use 'WHERE
IN FILE ' instead, but was wondering if there is any better way of overcoming the limitations?
Thank you!!
August 22, 2006, 04:00 PM
PrarieFrom the IBI site.
There is no limit to the number of WHERE statements in a FOCEXEC.
There is a limit to the number of test values in a WHERE statement.
Currently the buffersize to contain test values is 16,000 bytes for a
WHERE statement against a FOCUS database or relational table.
NOTE:The buffersize for an IF statement is 32,737.
The buffersize for SUFFIX=FIX or VSAM files is 3,200 for WHERE or IF
statements.
| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
August 23, 2006, 01:43 PM
KalThanks very much for this quick response, Prarie!
... Appreciate those additional Notes, its good to know!
Also, while I am here, let me also say
KUDOS TO ALL YOU CONTRIBUTORS!!
(Have been browsing through the Email-digest everyday, and they really help as in a steep learning curve.. You guys rule!! Thank you! )
August 23, 2006, 04:04 PM
GCohenThe size of the WHERE buffer used to be 32,000 characters. In the latest release this is probably unlimited. BUT, the database may have a limit on the maximum number of characters in a WHERE clause, and that was the reason we had a 32,000 limit.
Release 7.6.9
Windows
HTML