Re: SQL multiformat logical

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Closest thing I can think of is UNIONs, as you came to. Each SELECT 
could have some "format ID", a literal that you assign, plus the 
common fields from each file as separate columns, and finally a 
concatenation of whatever is left into a long character field. The 
program reading the file would need a way to break up this long field 
based on the format ID.

Or maybe just have the format ID and the common fields, then let the 
program using the result set take action to get the rest of the fields.

Eh? Whadya think?

Vern

At 02:31 PM 4/6/2006, you wrote:

> 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.