Re: Ruh Roh, STRSQL

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Dave

STRSQL works with every kind of physical file and almost every kind of 
logical file - it's been this way since at least 1991 when I first 
started looking at this stuff. Multi-format logicals, no. But not many 
even iSeries people use them anymore. Multiple members? There is a 
CREATE ALIAS to take care of that.

There've been many discussions in these lists about emulating the 
behavior of multi-format LFs with SQL - not always pretty but doable. 
But that's a bit off the direct topic, methinks.

I guess I don't know what you mean by the "non-DB2 multi-layered file 
structure" - I've never heard of anything on the i described that way. 
Please tell me more.

And keep on flying, my friend!!

Vern

On 1/20/2011 2:43 PM, BT Consulting wrote:
> David,
>
> Don't know if someone told you yet, but I doubt you'll be able to
> access the non-DB2 multi-layered file structure of the legacy
> way of doing things on the iSeries via STRSQL.  Since SQL is made to only access
> true RDBMS table structures and since the legacy iSeries file structure
> are non-RDMBS, you won't be able to do what you wish.  If you were
> accessing a true iSeries DB2 table structure created by the CREATE
> TABLE command or the similar way using native iSeries commands, then you'll be able to access it and use any SQL statement inside STRSQL.  If you need more info, let me know.
>
> Take care,
>
> Dave Odom