Kbase P38544: SQL92 Query - What is the limitation of elements per set
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
SQL92 Query - What is the limitation of elements per set
GOAL:
How to using SQL select statement with big where clause
GOAL:
Errors that can bee seen: Server not reachable or possible RPC error. (7488)
FACT(s) (Environment):
Progress 9.1D
FIX:
The limitation of elements per set in Progress 9.1D is 500
Example:
SELECT custnum FROM pub.customer WHERE pub.customer.custnum IN (SELECT custnum FROM pub.order);
A work around is to put the elements in a table and then use a select statement for the IN set like follow:
SELECT Sum(Pub."ord-prod"."qt-item") COLUMN1
FROM Pub."ord-prod"
WHERE Pub."ord-prod".Tipo in ('1','2','3') AND Pub."ord-prod".estado = 'R' AND Pub."ord-prod"."nr-ord-prod" IN (SELECT element FROM Pub.sets)