SQLIQBSZ parameter: Difference between revisions
Jump to navigation
Jump to search
m (misc formatting) |
|||
| (One intermediate revision by one other user not shown) | |||
| Line 15: | Line 15: | ||
==Description== | ==Description== | ||
<p> | <p> | ||
<p>This buffer is used for compilation and evaluation of SQL requests. It must be large enough to accommodate the greatest of the following quantities per request: </p> | <var>SQLIQBSZ</var> sets the size in bytes of a <var class="product">Model 204</var> SQL Engine internal buffer </p> | ||
<p> | |||
This buffer is used for compilation and evaluation of SQL requests. It must be large enough to accommodate the greatest of the following quantities per request: </p> | |||
<ul> | <ul> | ||
<li> | <li>The total length of a row fetched from <var class="product">Model 204</var> </li> | ||
The total length of a row fetched from <var class="product">Model 204</var> </li> | |||
<li> | <li>The total length of the data values of <var class="product">Model 204</var> indexed fields that are referenced in the WHERE clause of an SQL query</li> | ||
The total length of the data values of <var class="product">Model 204</var> indexed fields that are referenced in the WHERE clause of an SQL query</li> | |||
<li> | <li>The total data length of an insert or update query</li> | ||
The total data length of an insert or update query</li> | |||
<li> | <li>The numerical product of: | ||
The numerical product of: | |||
<ul> | <ul> | ||
<li> | <li>The number of columns in your SQL table</li> | ||
The number of columns in your SQL table</li> | |||
<li> | <li>The average length per column of the SQL catalog column description (that is, including names and attributes of the SQL column and <var class="product">Model 204</var> field)</li> | ||
The average length per column of the SQL catalog column description (that is, including names and attributes of the SQL column and <var class="product">Model 204</var> field)</li> | |||
</ul> | </ul> | ||
For example, the SQLIQBSZ default value typically accommodates a 250-column table whose average data length per column is 30 bytes. </li> | For example, the <var>SQLIQBSZ</var> default value typically accommodates a 250-column table whose average data length per column is 30 bytes. </li> | ||
</ul> | </ul> | ||
<p>If your SQLIQBSZ value is insufficient for your SQL data, you receive an [[Connect* | <p> | ||
<p>The SQLIQBSZ minimum is 2032 and its maximum is 32752. If your SQLIQBSZ setting is below the minimum or above the maximum, <var class="product">Model 204</var> forces the setting to either the minimum or maximum value.</p> | If your <var>SQLIQBSZ</var> value is insufficient for your SQL data, you receive an [[Connect* messages#Messages beginning with a minus (-) sign|SQL error code]] or <var class="product">Model 204</var> error message stating that your request is too long or your buffer is full. </p> | ||
<p>The SQLIQBSZ default is sufficient for most SQL applications.</p> | <p> | ||
The <var>SQLIQBSZ</var> minimum is 2032 and its maximum is 32752. If your <var>SQLIQBSZ</var> setting is below the minimum or above the maximum, <var class="product">Model 204</var> forces the setting to either the minimum or maximum value.</p> | |||
<p> | |||
The <var>SQLIQBSZ</var> default is sufficient for most SQL applications.</p> | |||
====Handling SQL statements greater than 32K bytes==== | ====Handling SQL statements greater than 32K bytes==== | ||
<p>When handling an SQL statement that is greater than 32K, you must consider that the SQLIQBSZ parameter is the buffer for the interface with IFAM. For example, set SQLIQBSZ=32752 to run an IFGET result that requires a buffer greater than 31K.</p> | <p> | ||
When handling an SQL statement that is greater than 32K, you must consider that the <var>SQLIQBSZ</var> parameter is the buffer for the interface with [[Introduction to the HLI facility#Model 204.27s Inverted File Access Method (IFAM)|IFAM]]. For example, set <code>SQLIQBSZ=32752</code> to run an <var>[[IFGET (HLI function)|IFGET]]</var> result that requires a buffer greater than 31K. | |||
</p> | |||
[[Category:User parameters]] | [[Category:User parameters]] | ||
[[Category:Parameters]] | [[Category:Parameters]] | ||
Latest revision as of 16:32, 7 September 2017
SQL intrnl query buff size
Summary
- Default value
- 8176
- Parameter type
- User
- Where set
- On User 0's or on user's parameter line
- Related products
- All
- Introduced
- Model 204 V3.1
Description
SQLIQBSZ sets the size in bytes of a Model 204 SQL Engine internal buffer
This buffer is used for compilation and evaluation of SQL requests. It must be large enough to accommodate the greatest of the following quantities per request:
- The total length of a row fetched from Model 204
- The total length of the data values of Model 204 indexed fields that are referenced in the WHERE clause of an SQL query
- The total data length of an insert or update query
- The numerical product of:
- The number of columns in your SQL table
- The average length per column of the SQL catalog column description (that is, including names and attributes of the SQL column and Model 204 field)
If your SQLIQBSZ value is insufficient for your SQL data, you receive an SQL error code or Model 204 error message stating that your request is too long or your buffer is full.
The SQLIQBSZ minimum is 2032 and its maximum is 32752. If your SQLIQBSZ setting is below the minimum or above the maximum, Model 204 forces the setting to either the minimum or maximum value.
The SQLIQBSZ default is sufficient for most SQL applications.
Handling SQL statements greater than 32K bytes
When handling an SQL statement that is greater than 32K, you must consider that the SQLIQBSZ parameter is the buffer for the interface with IFAM. For example, set SQLIQBSZ=32752 to run an IFGET result that requires a buffer greater than 31K.