• Subject: Re: Query Optimizer
  • From: "David Morris" <dmorris@xxxxxxxxxxxxx>
  • Date: Mon, 08 Nov 1999 16:19:52 -0700

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

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