Re: IDDU, S36 & AS/400 SQL & RPG -Reply

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."

-snip-

>Goodnight I'm Tired.
>John Carr
>EdgeTech

Cheers

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