RE: DB2/400 limit: 32 tables in one SELECT

["Walden Leverich" <walden@xxxxxxxxxxxxxxx>]

That is one hell of a select. I'm not aware of the limit being changed, but
you can try to circumvent it. Try making a view out of several of those
joins and then joining the view into the select. I'm not at the AS/400 now
so I can't try it, but the view may count as one table, even if it is made
up of several tables.

-Walden

PS. Can you possibly post the SQL. I'd be interested in seeing SQL that
joined 32 tables, maybe it can be optimized.

-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of Wiesmayr Rudolf
Sent: Friday, May 22, 1998 7:48 AM
To: 'MIDRANGE-L@midrange.com'
Subject: DB2/400 limit: 32 tables in one SELECT


Hi MidRangers!

One of our programmers fell over a restriction of DB2/400:
SQL0129 = Not more than 32 tables allowed in a SELECT...

That was under V3R6.

Does anybody know if and when this limit will be raisen?

Regards,
-----------------------------------------------------------------
Dipl.-Ing. Rudolf Wiesmayr   Tel:     +43 - 0732 / 7070 - 1720
Magistrat Linz, ADV/SB       Fax:     +43 - 0732 / 7070 - 1555
Gruberstrasse 40-42          mailto://Rudolf.Wiesmayr@mag.linz.at
A-4041 Linz                  IBMMAIL: at3vs7vs@ibmmail.com
------ http://www.linz.at <<<--- Digital City Linz, Austria -----
- City of Linz: awarded by 'Speyerer Qualitaetswettbewerb 1996' -

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---