× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.