Re: Limits on Selects and Omits (DDS)

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

I took a look at the Retrieve Database File Description (QDBRTVFD) 
API docs - here is one sentence from the select/omit section

"Total number of select/omit statements for all record formats, 1 
through 32,767."

There's other stuff there, like number of select/omit parameters in a 
statement - I think. This beast is not for the faint of heart, or for 
those with lives.

HT
Vern

At 06:28 AM 3/14/2007, you wrote:

> James,
>
> I tried searching a number of places.  Latest Gospel is:
> http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzamp/rzampoverview.htm
> But that says nothing.
>
> Sad that the DDS manual says only:
> http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzakb/rzakbmst.pdf
> There are limits to the number of select/omit statements you can specify
> in a single logical file. If you specify many select/omit statements and
> you cannot create the file, reduce the overhead for the file through the
> following changes in the specifications, in decreasing order of
> importance:
> - Reduce the number of record formats in the file.
> - Reduce the number of physical files specified on the PFILE or JFILE
> keyword.
> - Reduce the number of fields used (single occurrences) in the select/omit
> specifications.
>
> pdf page 27, printed page 20.
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> "James H H Lampert" <jamesl@xxxxxxxxxxx>
> Sent by: midrange-l-bounces+rob=dekko.com@xxxxxxxxxxxx
> 03/13/2007 05:34 PM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
>
>
> To
> midrange-l@xxxxxxxxxxxx
> cc
>
> Fax to
>
> Subject
> Limits on Selects and Omits (DDS)
>
>
>
>
>
>
> In the first place, please no harrangues about how selects
> and omits are extremely inefficient: I took the SQL
> optimization class in Rochester, I already know.
>
> Question is, one of the manuals says something about there
> being a limit on the number of selects and/or omits that
> can exist in a file. But I'm having trouble finding out
> what that limit is. Can anybody point me in the right
> direction?
>
> --
> JHHL
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.