RE: Summary view of arbitrary number ofidentically-named-and-form atted physical files in separate libraries

There you go Jim, finally a reason to move off of V2R3 and on to V5R3. :-)

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





CWilt@xxxxxxxxxxxx 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
09/22/2004 12:53 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
midrange-l@xxxxxxxxxxxx
cc

Fax to

Subject
RE: Summary view of arbitrary number ofidentically-named-and-form atted 
physical files in separate libraries








> -----Original Message-----
> From: Elvis Budimlic [mailto:ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx]
> Sent: Wednesday, September 22, 2004 1:36 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: Summary view of arbitrary number 
> ofidentically-named-and-formatted physical files in separate libraries
> 
> 
> Apparently, ORDER BY is allowed in CREATE TABLE, but not 
> CREATE VIEW.  As
> for the syntax, ORDER BY 3,2,4 would mean first order the 
> file by 3rd field,
> then 2nd and finally 4th field.

But it only affects the order in which the records are added to the file.
There isn't a key or anything created.

> 
> I could not find IBM document outlining physical limit on the 
> number of
> UNIONs in a single statement.  I think it may have been 
> raised to 256 in
> recent OS releases, but it would warrant testing to confirm that.

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/db2/rbafzmst165.htm

Most tables referenced in a view                                   32 

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/info/db2/rbafzm

stlimtabs.htm
Most tables referenced in a view                                 256 


Hm, learned something new here ;-)  Didn't know v5r3 had upped it to 256.
Thanks Elvis.

Charles

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.