Difference between revisions of "LSTBL parameter"

From m204wiki
Jump to navigation Jump to search
(Automatically generated page update)
 
(5 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
{{Template:LSTBL parameter subtitle}}
 
==Summary==
 
==Summary==
 
<dl>
 
<dl>
Line 6: 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
 
<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>
 +
 
==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 [[Large request considerations#STBL (character string table)|STBL]] 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&nbsp;204</var> V4R1.1, STBL usage increases in the SQL driver, because it relies fully on the <var class="product">Model&nbsp;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&nbsp;204</var> V4R1.1, STBL usage increases in the SQL driver, because it relies fully on the <var class="product">Model&nbsp;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]]

Latest revision as of 12:24, 6 July 2015

Length of STBL

Summary

Default value
600
Parameter type
Utable
Where set
On user's parameter line or reset by UTABLE command
Related products
All
Introduced
Model 204 V2.2 or earlier

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 Model 204 V4R1.1, STBL usage increases in the SQL driver, because it relies fully on the Model 204 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.