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

["Al Barsa, Jr." <barsa2@xxxxxxx>]

At 01:47 PM 5/22/98 +0200, you wrote:
>Hi MidRangers!
>
>One of our programmers fell over a restriction of DB2/400:
>SQL0129 = Not more than 32 tables allowed in a SELECT...
>
The limit of 32 joined files or 32 physical files in a multi-record format
logical file goes way back.  (Multi-record LF started at the beginning of
System/38, and join was a CPF release 7.0 implementation.)

I don't see any huge cry from AS/400 users to increase that, and I suspect
that it would be a big effort for IBM to do.

I wouldn't hold my breath.

Al



Al Barsa, Jr. - Account for Midrange-L
Barsa Consulting, LLC.  
400 > 390

Phone:  914-251-9400
Fax:    914-251-9406





Private mail should be sent to barsa@ibm.net
+---
| 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
+---