RE: SQL multiformat logical

Rob,

Not possible I'm afraid.

The idea of a multi-format logical breaks the RDB theorems SQL works on.

Heck if I remember right, you can't even do a select against a DDS
defined multi-format logical.

Union only works if all the columns are the same format, (or at least
compatible) so I wouldn't call that "multi-format"

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
> Sent: Thursday, April 06, 2006 3:32 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: SQL multiformat logical
> 
> Is there some way to do a multiformat logical file in SQL?  
> Or, instead of 
> that is there something else I can do to fit that same bill?  
> Must be SQL 
> and not DDS.  We're not really talking about any particularly 
> large files. 
>  Actually a small set of transaction data.  Like a days' worth of EDI 
> transmissions perhaps.  I am wondering if, instead of the multiformat 
> logical file I do something like
> CREATE TABLE...  AS SELECT ... UNION this and that and the 
> other thing. 
> Make sense?
> 
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 
> -- 
> 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.
> 
>