LSTBL parameter: Difference between revisions
Jump to navigation
Jump to search
m (Automatically generated page update) |
(Automatically generated page update) |
||
| 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 | [[Category:Utable parameters]] | ||
[[Category:Parameters]] | [[Category:Parameters]] | ||
Revision as of 19:01, 19 April 2013
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 V6.1 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.