Re: Query Optimizer

Bruce,

Actually, when a file is created with SQL vs DDS, the your choices change.  
For example, I don't believe you can add multiple members to a file 
created using SQL.  There are several other cross limitations.

David Morris

>>> "R. Bruce Hoffman, Jr" <rbruceh@ibm.net> 11/08/99 12:35PM >>>
Just going by what I have been told by the database guys at IBM.

Now, can you explain this "one member" theory to me? I mean, you CAN have
multiple members. You need overrides for SQL to get to them but nothing is
stopping you. Just because SQL won't create the multiple members, there is
nothing stopping you from changing it.


===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified AS/400 Professional System Administrator
 -- IBM Certified AS/400 Professional Network Administrator

"The sum of all human knowledge is a fixed constant.
    It's the population that keeps growing!"

-----Original Message-----
From: John P Carr <jpcarr@tredegar.com>
To: MIDRANGE-L <MIDRANGE-L@midrange.com>
Date: Monday, November 08, 1999 1:48 PM
Subject: Re: Query Optimizer


>
>
>Bruce said;
>>As for the difference between an index created by SQL and DDS, that
>depends.
>>Ultimately, the only real indication of where the logical was created is a
>>singular flag in the object.  It is not used for anything, it just
>indicates the source of the logical.
>
>I think it controls a few things like,   Only allowing to have 1 Member and
>things like that.
>
>John Carr


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@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
+---