When you wake up:

At 11:28 PM 12/11/97 -0500, you wrote:
>Date:  12/11/97  7:56 PM
>RE:    Re: IDDU, S36 & AS/400 SQL & RPG -Reply
>Hi, John
>Just some additions and clarifications:
><BIG Snip> -snip-
>>You can CREATE TABLE into a non-SQL library. That's what I did for SQLTEST,
>>as follows:
>>create table pgmrvmh/sqltest (field1 char(10) not null with default)
>>Lots of interesting stuff here. E.g., you can't retrieve records via an SQL
>>INDEX, although it's a logical file. However, the system uses it for
>>ordering records with ORDER BY clauses.
>>Vernon Hamberg
>Actually the INDEX (I believe) is not an Logical file.  PER SA (whatever)

Don't know details, but 'DB2 for OS/400 SQL Programming' says, "An SQL
index is a keyed logical file." and "A view in SQL is a special form of a
nonkeyed logical file."


>Goodnight I'm Tired.
>John Carr


Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN 55401
(612) 371-1111 x480

| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com

This thread ...


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

This mailing list archive is Copyright 1997-2019 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].