|
"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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
