Re: Query Optimizer

Hi Bruce,

I didn't believe it either, so I used SQL to create a table (PF), then tried
to CHGPF MAXMBRS(*NOMAX) and got the following error:

Message ID . . . . . . :   CPD3213       Severity . . . . . . . :   40
Message type . . . . . :   Diagnostic
Date sent  . . . . . . :   11/08/99      Time sent  . . . . . . :   16:24:22

Message . . . . :   Maximum-member value not valid for file SQLTEST.
Cause . . . . . :   File SQLTEST in library CC#PGMPCD is either a Structured
  Query Language (SQL) table, view or index, or a non-SQL file in SQL data
  base CC#PGMPCD.
    SQL tables, views, indexes, and non-SQL files that are in an SQL data
base
  must have only one member; however, the value that you specified on the
  maximum number of members (MAXMBRS) parameter is either a number greater
  than one or *NOMAX.  For more information about SQL tables, views and
  indexes, see the Programming: Structured Query Language Programmer's
Guide,
  SC41-9609.
Recovery  . . . :   Change the value in the MAXMBRS parameter to 1 or *SAME,
  and try the request again.

Bottom

Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax

----- Original Message -----
From: R. Bruce Hoffman, Jr <rbruceh@ibm.net>
To: <MIDRANGE-L@midrange.com>
Sent: Monday, November 08, 1999 11:35 AM
Subject: Re: Query Optimizer


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


__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com

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