Re: Ruh Roh, STRSQL

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