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