SQLIQBSZ parameter - Revision history

JAL: misc formatting

2017-09-07T16:32:01Z

misc formatting

← Older revision		Revision as of 16:32, 7 September 2017
Line 15:		Line 15:

	==Description==		==Description==
	<p>~~The~~ size in bytes of a <var class="product">Model 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 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*~~_messages~~#~~Messages_beginning_with_a_minus_.28~~-~~.29_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>
	<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 [[~~Introduction_to_the_HLI_facility~~#~~Model_204~~.~~27s_Inverted_File_Access_Method_.28IFAM.29~~\|IFAM]]. For example, set SQLIQBSZ=32752 to run an [[~~IFGET_~~(~~HLI_function~~)\|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]]

DCameron: /* Handling SQL statements greater than 32K bytes */

2017-09-07T13:04:21Z

Handling SQL statements greater than 32K bytes

← Older revision		Revision as of 13:04, 7 September 2017
Line 38:		Line 38:
	<p>The SQLIQBSZ default is sufficient for most SQL applications.</p>		<p>The SQLIQBSZ 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 SQLIQBSZ parameter is the buffer for the interface with [[Introduction_to_the_HLI_facility#Model_204.27s_Inverted_File_Access_Method_.28IFAM.29\|IFAM]]. For example, set SQLIQBSZ=32752 to run an [[IFGET_(HLI_function)\|IFGET]] result that requires a buffer greater than 31K.</p>
	[[Category:User parameters]]		[[Category:User parameters]]
	[[Category:Parameters]]		[[Category:Parameters]]

DCameron: /* Description */

2017-09-07T12:58:17Z

Description

← Older revision		Revision as of 12:58, 7 September 2017
Line 34:		Line 34:
	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 SQLIQBSZ 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 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>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 204</var> error message stating that your request is too long or your buffer is full. </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>		<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>
	<p>The SQLIQBSZ default is sufficient for most SQL applications.</p>		<p>The SQLIQBSZ default is sufficient for most SQL applications.</p>

DCameron: /* Summary */

2017-09-07T12:43:28Z

Summary

← Older revision		Revision as of 12:43, 7 September 2017
Line 11:		Line 11:
	<dd>All		<dd>All
	<dt>Introduced		<dt>Introduced
	<dd><var class="product">Model 204 V6.1</var> ~~or earlier~~		<dd><var class="product">Model 204 V3.1</var>
	</dl>		</dl>

	==Description==		==Description==
	<p>The size in bytes of a <var class="product">Model 204</var> SQL Engine internal buffer </p>		<p>The size in bytes of a <var class="product">Model 204</var> SQL Engine internal buffer </p>

DmeWiccan: Automatically generated page update

2013-08-27T16:44:04Z

Automatically generated page update

← Older revision		Revision as of 16:44, 27 August 2013
Line 1:		Line 1:
			{{Template:SQLIQBSZ parameter subtitle}}
	==Summary==		==Summary==
	<dl>		<dl>

DmeWiccan: Automatically generated page update

2013-04-23T02:06:14Z

Automatically generated page update

← Older revision		Revision as of 02:06, 23 April 2013
Line 37:		Line 37:
	====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 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>
	[[Category:User ~~Parameters~~]]		[[Category:User parameters]]
	[[Category:Parameters]]		[[Category:Parameters]]

Alex: Automatically generated page update

2013-02-28T00:56:57Z

Automatically generated page update

New page

==Summary==
<dl>
<dt>Default value
<dd>8176
<dt>Parameter type
<dd>User
<dt>Where set
<dd>On User 0's or on user's parameter line
<dt>Related products
<dd>All
<dt>Introduced
<dd><var class="product">Model 204 V6.1</var> or earlier
</dl>
==Description==
The size in bytes of a <var class="product">Model 204</var> 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: 
<ul>
<li>
The total length of a row fetched from <var class="product">Model 204</var> </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>
<li>
The total data length of an insert or update query</li>
<li>
The numerical product of:
<ul>
<li>
The number of columns in your SQL table</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>
</ul>
For example, the SQLIQBSZ default value typically accommodates a 250-column table whose average data length per column is 30 bytes. </li>
</ul>
If your SQLIQBSZ value is insufficient for your SQL data, you receive an SQL error code or <var class="product">Model 204</var> 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, <var class="product">Model 204</var> 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.
[[Category:User Parameters]]
[[Category:Parameters]]