Re: Ruh Roh, STRSQL

Vern,

Perhaps I didn't understand what the guy was talking about or I'm
mis-informed. In any event, I understood one couldn't use SQL against the old iSeries multi-format file structure used alot on the iSeries in older ways (not third-normal form) of creating a "file" instead of the modern way (at least third-normal form) of creating a DB2 table.

As to flying... too bad you weren't down here a few weeks ago when they had
a B-25, B-17 and B-29 at Deer Vally airport in PHX. I would have enjoyed
seeing them with you. Hope all is well there. Hope to see you again soon.

BTW, do you have any ideas on how to do the REXX/CGI stuff I mentioned in one
of my questions to this site? If you know the details of how its all set up,
I'd like to hear it. All I seem to find is vague references to it being
possible or ways to do it using PC REXX interpreters. I'd like to do as much
CGI/REXX work on the iSeries, as possible. Yes, there is always RPG (isn't that
Rocket Propelled Grenade?? hehehe) but I want to do prototyping first and
REXX is faster. Then, if needs be go to RPG or C. If you want to discuss
on the phone, send me your phone number to my email address on this post.

Thanks,

Dave

date: Thu, 20 Jan 2011 15:09:05 -0600
from: Vern Hamberg <vhamberg@xxxxxxxxxxx>
subject: 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

------------------------------

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest 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.



End of MIDRANGE-L Digest, Vol 10, Issue 96
******************************************