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

["Kris Vaidyanathan" <krishnan@xxxxxxxxxxxxxx>]

Just out of curiosity, why would you want to have 32 tables or more in one
select?
krisV

-----Original Message-----
From:   owner-midrange-l@midrange.com [mailto:owner-midrange-l@midrange.com]
On Behalf Of Wiesmayr Rudolf
Sent:   Friday, 22 May 1998 21:48
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
+---