MBSCAN parameter - Revision history

Goff: /* Description */

2025-02-10T22:06:13Z

Description

← Older revision		Revision as of 22:06, 10 February 2025
Line 24:		Line 24:
	If the count is greater than MBSCAN, you are told how many records must be searched, and you can choose either to perform the search or to cancel the request. In batch jobs, in application subsystems, or if the value of the <var>[[PROMPT_parameter\|PROMPT]]</var> parameter includes the hexadecimal 10 option, this interaction with you does not happen and the request is canceled.</li>		If the count is greater than MBSCAN, you are told how many records must be searched, and you can choose either to perform the search or to cancel the request. In batch jobs, in application subsystems, or if the value of the <var>[[PROMPT_parameter\|PROMPT]]</var> parameter includes the hexadecimal 10 option, this interaction with you does not happen and the request is canceled.</li>
	</ul>		</ul>
			<p>MSCAN is typically set for performance reasons. Do not reset it, especially to significantly larger values, without first consulting your DBAs as this may negatively impact overall performance.</p>
	[[Category:User parameters]]		[[Category:User parameters]]
	[[Category:Parameters]]		[[Category:Parameters]]

DCameron: /* Description */

2015-08-04T14:03:11Z

Description

← Older revision		Revision as of 14:03, 4 August 2015
Line 22:		Line 22:
	If the count is less than or equal to MBSCAN, the search is performed automatically. </li>		If the count is less than or equal to MBSCAN, the search is performed automatically. </li>
	<li>		<li>
	If the count is greater than MBSCAN, you are told how many records must be searched, and you can choose either to perform the search or to cancel the request. In batch jobs, in application subsystems, or if the value of the PROMPT parameter includes the hexadecimal 10 option, this interaction with you does not happen and the request is canceled.</li>		If the count is greater than MBSCAN, you are told how many records must be searched, and you can choose either to perform the search or to cancel the request. In batch jobs, in application subsystems, or if the value of the <var>[[PROMPT_parameter\|PROMPT]]</var> parameter includes the hexadecimal 10 option, this interaction with you does not happen and the request is canceled.</li>
	</ul>		</ul>
	[[Category:User parameters]]		[[Category:User parameters]]
	[[Category:Parameters]]		[[Category:Parameters]]

DCameron: /* Summary */

2015-08-04T13:58:47Z

Summary

← Older revision		Revision as of 13:58, 4 August 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 V9.0</var> or earlier
	</dl>		</dl>

	==Description==		==Description==
	<p>Whether <var class="product">Model 204</var> automatically performs a direct search and how many records are searched</p>		<p>Whether <var class="product">Model 204</var> automatically performs a direct search and how many records are searched</p>

ELowell: /* Description */

2014-07-31T15:36:41Z

Description

← Older revision		Revision as of 15:36, 31 July 2014
Line 15:		Line 15:
	==Description==		==Description==
	<p>Whether <var class="product">Model 204</var> automatically performs a direct search and how many records are searched</p>		<p>Whether <var class="product">Model 204</var> automatically performs a direct search and how many records are searched</p>
	<p>For Host Language Interface calls, if MBSCAN is zero, the direct search feature is disabled. If MBSCAN is nonzero, direct searches are always performed.</p>		<p>For SQL requests and Host Language Interface calls, if MBSCAN is zero, the direct search feature is disabled. If MBSCAN is nonzero, direct searches are always performed.</p>
	<p>For User Language, if MBSCAN is -1, all direct searches are performed automatically. If MBSCAN is zero, direct searches are never performed. When MBSCAN is greater than zero, <var class="product">Model 204</var> counts the records that would have to be searched after the inverted conditions have been evaluated. The count is compared to MBSCAN: </p>		<p>For User Language, if MBSCAN is -1, all direct searches are performed automatically. If MBSCAN is zero, direct searches are never performed. When MBSCAN is greater than zero, <var class="product">Model 204</var> counts the records that would have to be searched after the inverted conditions have been evaluated. The count is compared to MBSCAN: </p>
	<ul>		<ul>

DmeWiccan: Automatically generated page update

2013-08-27T16:40:08Z

Automatically generated page update

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

DmeWiccan: Automatically generated page update

2013-04-23T02:06:05Z

Automatically generated page update

← Older revision		Revision as of 02:06, 23 April 2013
Line 22:		Line 22:
	If the count is greater than MBSCAN, you are told how many records must be searched, and you can choose either to perform the search or to cancel the request. In batch jobs, in application subsystems, or if the value of the PROMPT parameter includes the hexadecimal 10 option, this interaction with you does not happen and the request is canceled.</li>		If the count is greater than MBSCAN, you are told how many records must be searched, and you can choose either to perform the search or to cancel the request. In batch jobs, in application subsystems, or if the value of the PROMPT parameter includes the hexadecimal 10 option, this interaction with you does not happen and the request is canceled.</li>
	</ul>		</ul>
	[[Category:User ~~Parameters~~]]		[[Category:User parameters]]
	[[Category:Parameters]]		[[Category:Parameters]]

Alex: Automatically generated page update

2013-02-28T00:56:17Z

Automatically generated page update

New page

==Summary==
<dl>
<dt>Default value
<dd>-1
<dt>Parameter type
<dd>User
<dt>Where set
<dd>By any user
<dt>Related products
<dd>All
<dt>Introduced
<dd><var class="product">Model 204 V6.1</var> or earlier
</dl>
==Description==
Whether <var class="product">Model 204</var> automatically performs a direct search and how many records are searched
For Host Language Interface calls, if MBSCAN is zero, the direct search feature is disabled. If MBSCAN is nonzero, direct searches are always performed.
For User Language, if MBSCAN is -1, all direct searches are performed automatically. If MBSCAN is zero, direct searches are never performed. When MBSCAN is greater than zero, <var class="product">Model 204</var> counts the records that would have to be searched after the inverted conditions have been evaluated. The count is compared to MBSCAN: 
<ul>
<li>
If the count is less than or equal to MBSCAN, the search is performed automatically. </li>
<li>
If the count is greater than MBSCAN, you are told how many records must be searched, and you can choose either to perform the search or to cancel the request. In batch jobs, in application subsystems, or if the value of the PROMPT parameter includes the hexadecimal 10 option, this interaction with you does not happen and the request is canceled.</li>
</ul>
[[Category:User Parameters]]
[[Category:Parameters]]