SQLIQBSZ parameter: Difference between revisions

From m204wiki
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>The size in bytes of a <var class="product">Model&nbsp;204</var> SQL Engine internal buffer </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&nbsp;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&nbsp;204</var> </li>
The total length of a row fetched from <var class="product">Model&nbsp;204</var> </li>
 
<li>
<li>The total length of the data values of <var class="product">Model&nbsp;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&nbsp;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&nbsp;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&nbsp;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*_messages#Messages_beginning_with_a_minus_.28-.29_sign|SQL error code]] or <var class="product">Model&nbsp;204</var> error message stating that your request is too long or your buffer is full. </p>
<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&nbsp;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&nbsp;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&nbsp;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)
    For example, the SQLIQBSZ default value typically accommodates a 250-column table whose average data length per column is 30 bytes.

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.