LSTBL parameter - Revision history

DCameron: /* Summary */

2015-07-06T12:24:05Z

Summary

← Older revision		Revision as of 12:24, 6 July 2015
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 V2.2</var> or earlier
	</dl>		</dl>

DCameron: /* Summary */

2015-07-06T12:20:38Z

Summary

← Older revision		Revision as of 12:20, 6 July 2015
Line 7:		Line 7:
	<dd>Utable		<dd>Utable
	<dt>Where set		<dt>Where set
	<dd>On user's parameter line or reset by <var>[[~~Utable_command~~\|UTABLE]]</var> command		<dd>On user's parameter line or reset by <var>[[UTABLE_command\|UTABLE]]</var> command
	<dt>Related products		<dt>Related products
	<dd>All		<dd>All

DCameron: /* Summary */

2015-07-06T12:19:59Z

Summary

← Older revision		Revision as of 12:19, 6 July 2015
Line 7:		Line 7:
	<dd>Utable		<dd>Utable
	<dt>Where set		<dt>Where set
	<dd>On user's parameter line or reset by UTABLE command		<dd>On user's parameter line or reset by <var>[[Utable_command\|UTABLE]]</var> command
	<dt>Related products		<dt>Related products
	<dd>All		<dd>All
Line 13:		Line 13:
	<dd><var class="product">Model 204 V6.1</var> or earlier		<dd><var class="product">Model 204 V6.1</var> or earlier
	</dl>		</dl>

	==Description==		==Description==
	<p>		<p>

JAL: /* Description */

2015-04-08T18:48:17Z

Description

← Older revision		Revision as of 18:48, 8 April 2015
Line 15:		Line 15:
	==Description==		==Description==
	<p>		<p>
	The size of ~~<var>~~[[Large request considerations#STBL (character string table)\|STBL]]~~</var>~~ in bytes.</p>		The size of [[Large request considerations#STBL (character string table)\|STBL]] in bytes.</p>
	<p>		<p>
	STBL is used for storing character strings and arrays. <var>LSTBL</var> can range from 0 to 16777208. For an application subsystem user, <var>LSTBL</var> must have a minimum value of 250.</p>		STBL is used for storing character strings and arrays. <var>LSTBL</var> can range from 0 to 16777208. For an application subsystem user, <var>LSTBL</var> must have a minimum value of 250.</p>

JAL: add link

2015-04-08T18:45:41Z

add link

← Older revision		Revision as of 18:45, 8 April 2015
Line 14:		Line 14:
	</dl>		</dl>
	==Description==		==Description==
	<p>The size of STBL in bytes</p>		<p>
	<p>STBL is used for storing character strings and arrays. LSTBL can range from 0 to 16777208. For an application subsystem user, LSTBL must have a minimum value of 250.</p>		The size of <var>[[Large request considerations#STBL (character string table)\|STBL]]</var> in bytes.</p>
			<p>
			STBL is used for storing character strings and arrays. <var>LSTBL</var> can range from 0 to 16777208. For an application subsystem user, <var>LSTBL</var> must have a minimum value of 250.</p>

	====STBL usage and the SQL driver====		====STBL usage and the SQL driver====
	<p>Beginning in <var class="product">Model 204</var> V4R1.1, STBL usage increases in the SQL driver, because it relies fully on the <var class="product">Model 204</var> nucleus to create and process a found set derived from the WHERE clause in the query. This bypasses a Table B search whenever possible and increases performance. </p>		<p>
	<p>Rocket Software recommends that sites using SQL set STBL to a minimum of 3000 bytes, keeping in mind that the size requirement relates directly to the complexity of the query and/or the view structure.</p>		Beginning in <var class="product">Model 204</var> V4R1.1, STBL usage increases in the SQL driver, because it relies fully on the <var class="product">Model 204</var> nucleus to create and process a found set derived from the <code>WHERE</code> clause in the query. This bypasses a Table B search whenever possible and increases performance. </p>
			<p>
			Rocket Software recommends that sites using SQL set STBL to a minimum of 3000 bytes, keeping in mind that the size requirement relates directly to the complexity of the query and/or the view structure.</p>

	[[Category:Utable parameters]]		[[Category:Utable parameters]]
	[[Category:Parameters]]		[[Category:Parameters]]

DmeWiccan: Automatically generated page update

2013-08-27T16:39:02Z

Automatically generated page update

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

DmeWiccan: Automatically generated page update

2013-04-19T19:01:14Z

Automatically generated page update

← Older revision		Revision as of 19:01, 19 April 2013
Line 18:		Line 18:
	<p>Beginning in <var class="product">Model 204</var> V4R1.1, STBL usage increases in the SQL driver, because it relies fully on the <var class="product">Model 204</var> nucleus to create and process a found set derived from the WHERE clause in the query. This bypasses a Table B search whenever possible and increases performance. </p>		<p>Beginning in <var class="product">Model 204</var> V4R1.1, STBL usage increases in the SQL driver, because it relies fully on the <var class="product">Model 204</var> nucleus to create and process a found set derived from the WHERE clause in the query. This bypasses a Table B search whenever possible and increases performance. </p>
	<p>Rocket Software recommends that sites using SQL set STBL to a minimum of 3000 bytes, keeping in mind that the size requirement relates directly to the complexity of the query and/or the view structure.</p>		<p>Rocket Software recommends that sites using SQL set STBL to a minimum of 3000 bytes, keeping in mind that the size requirement relates directly to the complexity of the query and/or the view structure.</p>
	[[Category:Utable ~~Parameters~~]]		[[Category:Utable parameters]]
	[[Category:Parameters]]		[[Category:Parameters]]

Alex: Automatically generated page update

2013-02-28T00:56:12Z

Automatically generated page update

New page

==Summary==
<dl>
<dt>Default value
<dd>600
<dt>Parameter type
<dd>Utable
<dt>Where set
<dd>On user's parameter line or reset by UTABLE command
<dt>Related products
<dd>All
<dt>Introduced
<dd><var class="product">Model 204 V6.1</var> or earlier
</dl>
==Description==
The size of STBL in bytes
STBL is used for storing character strings and arrays. LSTBL can range from 0 to 16777208. For an application subsystem user, LSTBL must have a minimum value of 250.
====STBL usage and the SQL driver====
Beginning in <var class="product">Model 204</var> V4R1.1, STBL usage increases in the SQL driver, because it relies fully on the <var class="product">Model 204</var> nucleus to create and process a found set derived from the WHERE clause in the query. This bypasses a Table B search whenever possible and increases performance. 
Rocket Software recommends that sites using SQL set STBL to a minimum of 3000 bytes, keeping in mind that the size requirement relates directly to the complexity of the query and/or the view structure.
[[Category:Utable Parameters]]
[[Category:Parameters]]